Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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, which runs at 2.93GHz, and can go to 3.60GHz with… Read more

0 comments, 621 reads

Posted in Glenn Berry's SQL Server Performance on 28 May 2010

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 is free, but you need to register in… Read more

1 comments, 312 reads

Posted in Glenn Berry's SQL Server Performance on 26 May 2010

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, with a lot of good questions at the end. I… Read more

5 comments, 910 reads

Posted in Glenn Berry's SQL Server Performance on 19 May 2010

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 makes sense, because the compile date for Build 1600… Read more

5 comments, 1,751 reads

Posted in Glenn Berry's SQL Server Performance on 18 May 2010

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 update, and most of them are for Reporting Services and… Read more

3 comments, 673 reads

Posted in Glenn Berry's SQL Server Performance on 18 May 2010

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 pressure. Since most modern database servers have significant extra CPU… Read more

3 comments, 178 reads

Posted in Glenn Berry's SQL Server Performance on 17 May 2010

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 pressure. Since most modern database servers have significant extra CPU… Read more

3 comments, 604 reads

Posted in Glenn Berry's SQL Server Performance on 17 May 2010

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), I discovered some new information that can be uncovered in… Read more

4 comments, 1,012 reads

Posted in Glenn Berry's SQL Server Performance on 11 May 2010

Five Things SQL Server Should Drop

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 I just want to chime in. Many “accidental”… Read more

1008 comments, 5,965 reads

Posted in Glenn Berry's SQL Server Performance on 11 May 2010

Finding Enterprise Only Features in Your SQL Server 2008 Database

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
-- http://glennberrysqlperformance.spaces.live.com/
-- Twitter: GlennAlanBerry

    -- Look for Enterprise only features…

Read more

3 comments, 537 reads

Posted in Glenn Berry's SQL Server Performance on 10 May 2010

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

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 is below:

Dr. DMV: How to Use Dynamic Management… Read more

2 comments, 319 reads

Posted in Glenn Berry's SQL Server Performance on 7 May 2010

Denver SQL Server User’s Group Meeting on Thursday, May 20, 2010

The Denver SQL Server User’s Group will be having their May meeting next Thursday, May 20. As always, the meeting will be held at AmeriTeach, which is located at:

AmeriTeach
7800 East Dorado Place, Suite 150
Greenwood Village, CO 80111
720-346-1710


Meeting Agenda:
5:30 - 6:00 - Food / Socializing

Read more

3 comments, 208 reads

Posted in Glenn Berry's SQL Server Performance on 7 May 2010

Some SQL Server Date and Time Examples

I had a question from a developer yesterday about how to calculate the difference between local time (on the database server), and UTC Time. This needed to work in SQL Server 2005. It turns out that this is pretty easy to do in T-SQL, even in SQL Server 2005. I… Read more

4 comments, 748 reads

Posted in Glenn Berry's SQL Server Performance on 6 May 2010

Using CPU-Z to Discover Hardware Information

I think it is very important to be able to discover exactly what type of hardware is in an existing database server, along with how it is configured. I am always disappointed when I ask someone what kind of hardware is in one of their servers, and I get some… Read more

2 comments, 418 reads

Posted in Glenn Berry's SQL Server Performance on 5 May 2010

Spring 2010 Hardware Recommendations

Since I am very interested in various PC-based hardware, and I make an effort to stay current on new developments, I thought I would make some generic hardware recommendations in case you are in the market for new hardware. I am not going to recommend specific brands or models, but… Read more

1 comments, 481 reads

Posted in Glenn Berry's SQL Server Performance on 4 May 2010

Register For 24 Hours of PASS Event

The free 24 Hours of PASS event will be held on May 19-20, and includes 24 different one hour presentations and demonstrations by a group of well known SQL Server experts on many different aspects of SQL Server, with a special emphasis on SQL Server 2008 R2. This is a… Read more

2 comments, 244 reads

Posted in Glenn Berry's SQL Server Performance on 3 May 2010

Recap of April 2010 DMV a Day Series

Well, I managed to finish up my series that featured a DMV query every day during the month of April. I appreciate all of the comments and feedback I received. One suggestion I got from several readers was to recap the series in a single post at the end, which… Read more

7 comments, 1,610 reads

Posted in Glenn Berry's SQL Server Performance on 3 May 2010