SQL Server 2012 adds a new stored procedure called sp_describe_first_result_set. This new procedure returns metadata for the result set returned from a query. The metadata is information about what the results will look like. sp_describe_first_result_set is an alternative to sp_columns, and appears …
T-SQL 2012 Procedure sp_describe_first_result_set Read more »
# The key to twitter is to follow the right hash tags. What hash tags do you follow related to Microsoft SQL Server? Here are a few of the twitter hash tags that I follow: #SQLServer The generic SQL Server …
What twitter hash tags do you follow for SQL Server? Read more »
It has been a year since SQL Server 2012 released. There were some fun posts on Twitter about the SQL Server 2012 birthday or anniversary. For instance: and another anniversary query (which doesn’t actually run): 1 year out since SQL …
SQL Server 2012 introduces the IIF statement. It is very similar to the IIF statement in MS Access. I have extracted the IIF part of my presentation on Whats new in SQL Server 2012, and turned it into a video …
Throughout my career I have worked with different programming and database tools. Thinking back the tools that I enjoyed using were the tools that were easy to get the job done, and the tools that I hated using were the …
Last year while working on my CTE presentation for a SQL Saturday I added a blog post called “Using a CTE to Split a String Into Rows“, and since that posting I have used it many times. But as things …
Using a CTE to Split a String Into Rows with Line Numbers Read more »
After writing a recent blog post on Are you wasting half the capacity of IDENTITY, I started thinking about how much is too big for an BIGINT IDENTITY. If you don’t know about, you can get Are you wasting half the capacity …
I just finished the Exploring the TSQL Enhancements in SQL Server 2012 presentation at SQL Saturday 166 in Olympia Washington. Thanks everyone who attended, I hope that you learned something useful. Here is the slides and sample code to download: Whats …
Exploring the TSQL Enhancements in SQL Server 2012 – Slides and Sample Code Read more »
The sample code below is a quick run down of the new sequence object introduced in SQL Server 2012. Just part of my Whats New in TSQL 2012 presentation at SQL Saturday 166.
SQL Server 2012 introduces the SEQUENCE object. Looking at the syntax it is very similar to how Oracle has implemented SEQUENCEs for many years. I believe that the SEQUENCE was introduced to aid in the transition of Oracle developers to …