|
|
-
|
|
I found this question in this SSC forum thread requesting help to shape the XML document. Here is the input XML document.
Jhon
Luka
1
2
The expected output is as follows.
Jhon
Luka
1
2
This type of formatting can be achieved through a......
|
|
-
|
|
Pinal Dave is an inspiration for a large number of SQL Server professionals all over the world. He is a great teacher who knows how to explain any complex stuff in very simple words and examples that everyone understands. That is the reason why his blog is considered to be one of the best source of ......
|
|
-
|
|
I got a question in my personal forum this morning requesting help to read values from an XML column. My first reaction was “Well, there is an XQuery lab demonstrating this!”. However, after reviewing the existing XQuery labs, I realized there are no posts demonstrating this. Here is a simple exam......
|
|
-
|
|
One of the problems I came across while writing the partitioning chapter for my FILESTREAM book is that the partitioning does not work correctly with RANGE LEFT. It works as expected when using RANGE RIGHT. Something is wrong with RANGE LEFT and the problem exists in SQL Server 2008, R2 and Denali C......
|
|
-
|
|
SQL Server Wait Types are important factors to consider while analyzing performance problems of SQL Server databases. If you notice a particular wait type is occurring too often or for too long, it indicates a problem in most cases. There are several dozens of different wait types and it is quite i......
|
|
-
|
|
I have been watching the TSQL Tuesday Blog Parties for quite some time and this is the first time I am participating in it. T-SQL Tuesday #16 is hosted by Jes Schultz Borland and the topic is Aggregation. Aggregating and summarizing data is a common business requirement. Very often we come acros......
|
|
-
|
|
We are back with the first SQL Server Quiz of year 2011 – TSQL Quiz 2011. The quiz started on 1st March and will run until 31 March 2011. There are 31 questions in this series and a question is published every day. Congratulations to the Winners of SQL Server Quiz 2010 We did a similar quiz a few ......
|
|
-
|
|
TSQL Challenges – 2nd Birthday Party! TSQL Challenges is turning two years old today. We did the first TSQL Challenge two years ago - on 27th February 2009. In two years, TSQL Challenge has grown up with the help of several volunteers and TSQL enthusiasts who stepped in and selflessly helped. I hav......
|
|
-
|
|
“Juneau” is the code name given to the new SQL Server development environment which is based on Visual Studio shell. It is officially named “SQL Server Developer Tools” (SSDT) which is expected to provide a wide range of functionalities that are currently not available with SQL Server Management Stu......
|
|
-
|
|
Project Crescent is a new data visualization tool that will be part of the next version of SQL Server – code named Denali. “Crescent” is the code name given to the new reporting/visualization tools and it looks like the name may change by the time the product is released. Crescent is expected to r......
|
|