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