A long, long time ago in a galaxy you can reach out and touch right now, ORDER BY in a VIEW meant something. If you had a view like the following: CREATE VIEW dbo.Rubbish AS SELECT TOP 100 PERCENT Trash FROM dbo.Garbage ORDER BY Trash; And then you ran a […]
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 […]
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 […]
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 – […]