CTE and joins begin Day 16 of the original interview series. The ten questions remain with corrected examples and clearer answers about XML, CLR, synonyms, and locking.
Interview Questions and Answers – FAQ Day 14 of 31
FAQ Day 14 of my interview series starts with the basic functions of the master, msdb, model, tempdb and resource databases in SQL Server 2008.
SQL SERVER – Query to Find Duplicate Indexes – Script to Find Redundant Indexes
Duplicate indexes are pure overhead on every insert, update and delete. Here is my script to find duplicate and overlapping indexes so you can review them.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 11 of 31
Frequently Asked Questions Day 11: do table and column aliases affect performance, and what is the difference between CHAR and VARCHAR?
SQL SERVER – Find Details for Statistics of Whole Database
Need statistics of whole database in one view? My script uses DMVs instead of the deprecated sp_helpstats and shows each stat, column and last update.
CROSS JOIN: Duplicate Inputs Multiply the Result
CROSS JOIN multiplies row counts, including repeated labels. Keep source identifiers and grouped pair counts visible while checking result grain.
SQL SERVER – Puzzle Involving NULL – Resolve – Error – Operand data type void type is invalid for sum operator
SELECT SUM over a lone NULL throws Msg 8117: Operand data type void type is invalid for sum operator. Here is why it happens and how ISNULL fixes it.






