Daily Archives: April 4, 2012

Using 2008 Features in a 2000 Compatibility Database

I saw a note recently from someone asking if they could use CROSS APPLY on a SQL Server 2008 instance with an older database in SQL 2000 compatibility mode. You can. CREATE DATABASE sql2kCompat ; go ALTER DATABASE SQL2KCompat SET … Continue reading

Posted in Blog | Tagged , ,

My Little Friend

Say hello to my little friend: This button is my favorite part of Management Studio. It’s on every dialog that I’ve seen in the 2012 version of the tool and I’ve begun using it quite liberally. At a recent talk, … Continue reading

Posted in Editorial | Tagged | 2 Comments