Bad habits : Counting rows the hard way
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 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.
Microsoft has released Cumulative Update #4 for SQL Server 2014. KB Article: KB #2999197 66 fixes total (54 fixes listed publicly at time of publication), including several fixes for Management Studio. Build number is...
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.
Tip : Drop and Re-Create All Foreign Key Constraints in SQL Server