Build SQL Server graph tables for follows, mutual connections and friends of friends, then use shortest paths and compare a junction table.
Storing Emoji and Short Messages: nvarchar, UTF-8 and Length
Store emoji safely with nvarchar or UTF-8 varchar, compare LEN and DATALENGTH, and choose message limits that fit full Unicode.
Cleaning Messy Data With T-SQL
Cleaning messy data With T-SQL means trimming text, parsing dates safely, and preserving rejected source rows for correction and replay.
SQL SERVER – DMV sys.dm_exec_describe_first_result_set_for_object – Describes the First Result Metadata for the Module
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 – 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?










