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.
Monthly Archive: October 2014
Bad habits: Another case for semi-colons and schema prefix
I repeat "Bad habits" advice from the past about using statement terminators and schema references to avoid debugging troubles.
SQL Server 2014 Cumulative Update #4 is available!
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...
Readable Secondaries on a Budget
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.
Map between SQL Server SIDs and Windows SIDs
Tip : Map between SQL Server SIDs and Windows SIDs
Bad habits: Using AttachDBFileName
I point out that an often-used connection setting, AttachDBFileName, may be the source of many wasted hours of debugging and troubleshooting.
Drop and Re-Create All Foreign Key Constraints in SQL Server
Tip : Drop and Re-Create All Foreign Key Constraints in SQL Server