Bad Habits to Kick : Believing everything you hear or read

I read a statement on a forum recently that said something like: IDENTITY columns are the primary key, and primary keys are clustered. Wow. My first thought was, "I hope people aren't learning from this." Unfortunately, I suspect a few already have, as no matter what you write on the […]

Two new cumulative updates for SQL Server 2008 R2 are available!

Last night Microsoft released two new cumulative updates for SQL Server 2008 R2: Cumulative Update 5 for SQL Server 2008 R2 SP1 KB #2659694 Build 10.50.2806 16 fixes, including a nasty SCOPE_IDENTITY() bug and several performance fixes. My recommendation: You should test and plan for this update if SELECT @@VERSION […]

Upgrading to SQL Server 2012 with Lock Pages in Memory

During SQL Server 2012 RC0 setup (specifically when upgrading), you may have noticed upgrade rules regarding Lock Pages in Memory (LPIM): However, for most folks, these rules always pass, whether or not they are actually using LPIM. I wanted to run a few tests to demonstrate why this is – […]