The SQL Server 2012 DMV sys.dm_exec_describe_first_result_set_for_object describes the result columns of a stored procedure.
Triangular Joins: The Hidden Row Explosion in Self-Joins
A small grouped result can hide a huge pile of row pairs. Here is how to count them and what to do instead.
SQLAuthority News – #TechEdIn – TechEd India 2012 Memories and Photos
TechEd India 2012 in Bangalore was bigger and grander than ever. Here are my TechEd India 2012 memories and photos, a family affair as always.
SQL SERVER – Cleaning Up SQL Server Indexes – Defragmentation, Fillfactor – Video
Cleaning up SQL Server indexes starts with fragmentation. Learn the two types, when to reorganize or rebuild, and how fillfactor fits in.
SQL SERVER – FIX: ERROR Msg 5169, Level 16: FILEGROWTH cannot be greater than MAXSIZE for file
Msg 5169, FILEGROWTH cannot be greater than MAXSIZE for file, stumped a friend new to SQL Server. Here is how I recreated the error and fixed it.
SQL SERVER – Use ROLL UP Clause instead of COMPUTE BY
After an upgrade to SQL Server 2012, reports failed because COMPUTE BY is deprecated. I show how to rewrite such queries with the ROLL UP clause.
SQL SERVER – A Puzzle – Illusion – Confusion – April Fools’ Day
A light puzzle for April Fools’ Day: two division queries that look the same in SSMS. Will they return the same result, and why?