Jacob's Blog

This post is inspired by a question I saw in the forum this morning. The requirement is to be able to read the attributes belonging to a particular namespace. I thought of writing an XQuery lab to explain this. Here is the sample XML we have for this la...

I have done several domain transfers from one registrar to another, however, never did an account change. I wanted to transfer a domain from my personal account to beyondrelational.com account at Godaddy and was trying to do a domain transfer (whooops!)...

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......