Monthly Archives: May 2010

New Unlocked CPUs From Intel

AnandTech has an interesting review up about some new models of Core i5 and Core i7 processors that are designed to be easier for system OEMs to “factory overclock”. What I found interesting is the new Core i7 875K processor, … Continue reading

Posted in Computer Hardware | Leave a comment

Kalen Delaney Speaking In Denver on June 9, 2010

Well-known SQL Server MVP and author Kalen Delaney (blog) will be speaking  about SQL Server Plan Cache and Recompilation on Wednesday, June 9, 2010 at the Denver Marriot Tech Center on 4900 South Syracuse Street, Denver, CO 80237. The event … Continue reading

Posted in Teaching | Leave a comment

SQL Server Utility Script From 24 Hours of PASS

I had a good time giving my presentation and demo of SQL Server Utility during the fourth hour of the 24 Hours of PASS this morning at 9:00AM Mountain time. We had close to 700 attendees in the Live Meeting, … Continue reading

Posted in SQL Server 2008 R2 | 1 Comment

SQL Server 2008 R2 RTM Cumulative Update 1 (Build 1702) Released

I also just discovered that Microsoft released SQL Server 2008 R2 RTM CU1 yesterday. It is Build 1702, and it contains 76 fixes. Even though this seems really soon after the official RTM of SQL Server 2008 R2, it actually … Continue reading

Posted in SQL Server 2008 R2 | Leave a comment

SQL Server 2008 SP1 Cumulative Update 8 Released

Microsoft has released SQL Server 2008 SP1 CU8 (Build 2775). There is no corresponding CU for the RTM branch of SQL Server 2008, since the RTM branch was “retired” on April 13, 2010. I count 18 fixes in this cumulative … Continue reading

Posted in SQL Server 2008 | Leave a comment

Some Data Compression Commands for SQL Server 2008 and 2008 R2

One of the more interesting and valuable features in SQL Server 2008 R2 Enterprise Edition (and Datacenter Edition) is data compression. Data compression can help relieve both memory and I/O pressure at the cost of a little bit of CPU … Continue reading

Posted in SQL Server 2008 R2 | 1 Comment

Some New DMV Queries for SQL Server 2008 R2

I was spelunking around in SQL Server 2008 R2 today, after looking at a PowerPoint presentation by Madhan Arumugam about some of the low-level engine improvements in SQL Server 2008 R2 (when it is running on Windows Server 2008 R2), … Continue reading

Posted in SQL Server 2008 R2 | 2 Comments