SQLCAT.Com – eBook Downloads

As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication.  MSDN SQLCAT blogs already includes most SQLCAT.COM Content and will continue to be updated with more SQLCAT learnings.  You can also… Read more

Unexpected Consequences of Multiple Result Sets

Author:            Chuck Heinzelman Reviewers:     Kevin Cox, Kun Cheng, Michael Thomassy In a recent customer engagement, I was presented with a problem that I have seen in the past and am surprised that I don’t see more often. Take the following table as an example: CREATE TABLE dbo.ResultSetTest (    ID       integer      IDENTITY(1,1) NOT NULL PRIMARY… Read more