Monthly Archives: May 2010

New Unlocked CPUs From Intel

Posted on May 28, 2010 by Glenn Berry

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

Posted on May 26, 2010 by Glenn Berry

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

Posted on May 19, 2010 by Glenn Berry

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

Posted on May 18, 2010 by Glenn Berry

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

Posted on May 18, 2010 by Glenn Berry

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

Posted on May 17, 2010 by Glenn Berry

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

Posted on May 11, 2010 by Glenn Berry

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

Five Things SQL Server Should Drop

Posted on May 11, 2010 by Glenn Berry

Joining in the current meme started by Paul Randal (blog | twitter), here is my list of five features or settings that SQL Server should not have. The current SQL Server setup program. Several people have commented on this, but … Continue reading →

Posted in SQL Server 2008 R2 | 1 Comment

Finding Enterprise Only Features in Your SQL Server 2008 Database

Posted on May 10, 2010 by Glenn Berry

Microsoft added a new DMV, sys.dm_db_persisted_sku_features to SQL Server 2008 that you can use to determine whether you have any Enterprise Edition only features in a particular database. — Detect Enterprise Edition Features — Glenn Berry — May 2010 — … Continue reading →

Posted in SQL Server 2008 | 1 Comment

Colorado Springs SQL Server User’s Group Meeting on Wednesday, May 19, 2010

Posted on May 7, 2010 by Glenn Berry

The Colorado Springs SQL Server User’s Group is having their May meeting on May 19. It will be held at the Ruth Holley Public Library in Colorado Springs. I will be presenting my Dr. DMV presentation and demo. The abstract … Continue reading →

Posted in Teaching | Leave a comment