SQL Server Denali CTP 3 and 2008 R2 SP1 released

July 12th was a good day for all SQL Server enthusiasts and professionals as Microsoft announced the release of both Service Pack 1 for SQL Server 2008 R2 as well as Community Technology Preview 3 for the next installment in the series, Codename Denali.

SP1 brings with it a number of stability and security fixes as well as some more advanced configuration options to fine-tune performance.  The most interesting update from my point of view is the updated syntax on the FORCESEEK index hint, which now has extra options to further fine tune queries. Continue reading “SQL Server Denali CTP 3 and 2008 R2 SP1 released” »