I show some tricks for getting row counts efficiently, and explain why an accurate row count for a large table is a pipe dream.

I repeat "Bad habits" advice from the past about using statement terminators and schema references to avoid debugging troubles.

I demonstrate an affordable approach to readable secondaries, without the need for Availability Groups and all the licensing costs involved with Enterprise Edition and Software Assurance.

Tip : Map between SQL Server SIDs and Windows SIDs

I point out that an often-used connection setting, AttachDBFileName, may be the source of many wasted hours of debugging and troubleshooting.

In this tip, I show how to use dynamic SQL to drop and re-create all foreign keys.