Why people think some SQL Server 2000 behaviors live on… 12 years later
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...
Monthly Archive: February 2012
Checking for potential constraint violations before entering SQL Server TRY and CATCH logic
Tip : Checking for potential constraint violations before entering SQL Server TRY and CATCH logic
Bad Habits to Kick : Believing everything you hear or read
By way of an example, see why most of what you hear about SQL Server is only true some of the time, at best.
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...
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...
Troubleshooting IntelliSense in SQL Server Management Studio 2012
Tip : Troubleshooting IntelliSense in SQL Server Management Studio 2012