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

Archives: June 2010

How To Stay Current with SQL Server Cumulative Updates

Since the release of SQL Server 2005, Microsoft has been using what they call an Incremental Servicing Model for SQL Server. This means that every eight weeks, they release a cumulative update (CU) for a particular version and service pack of SQL Server. These cumulative updates typically have about 20-40…

Read more

3 comments, 1,162 reads

Posted in Glenn Berry's SQL Server Performance on 23 June 2010

Microsoft Releases SQL Server 2008 R2 RTM Cumulative Update 2

Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 2 (CU2) today. It became available for download today, and you can request it here. This is Build 1720, and it includes 18 fixes, mostly for Analysis Services and Reporting Services.

Below is a SQL Server 2008, SQL Azure,… Read more

1 comments, 1,912 reads

Posted in Glenn Berry's SQL Server Performance on 23 June 2010

Detecting and Reducing VLFs in SQL Server 2008/2008 R2 Transaction Log Files

One common, but often undetected issue that I see with SQL Server databases is a very high number of virtual log files (VLFs) inside the SQL Server transaction log file. This usually occurs because the default initial size and autogrowth increment are both far too small for most production databases.… Read more

5 comments, 1,683 reads

Posted in Glenn Berry's SQL Server Performance on 22 June 2010

Inverter Obsession, or Why I am Starting to Hate Clouds

After getting my new grid-tied solar PV system turned on and operational on June 18, 2010, I have become temporarily obsessed with going outside and looking at the LCD display on my SunPower 3000m inverter to see how much power is being generated by the system. Since January 2010,… Read more

2 comments, 305 reads

Posted in Glenn Berry's SQL Server Performance on 21 June 2010

Promoted to TempDB by SQLRockstar

I noticed today that fellow SQL Server MVP Thomas LaRock (blog | twitter) had updated his SQL Server blog rankings, and promoted me to be on the TempDB list. That was quite a nice surprise, and a good way to start out the week. It is amazing… Read more

2 comments, 285 reads

Posted in Glenn Berry's SQL Server Performance on 21 June 2010

3.15Kw Grid-Tied Solar PV System Online

I took a day off work so I could be here when Namaste Solar and IREA came out to my house to replace my old electric meter with one that is capable of net-metering. This allows you to sell any excess electricity that you generate back to the utility company.… Read more

0 comments, 364 reads

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

Teaching ICT 4462 – Transact SQL Programming at Denver University, University College

I will be teaching a special five week version of ICT 4462 – Transact SQL Programming at Denver University, University College starting on Monday, July 12, 2010. The class will meet on campus, on Monday and Thursday nights. It will have the same content as the regular 10 week class,… Read more

0 comments, 299 reads

Posted in Glenn Berry's SQL Server Performance on 15 June 2010

How To Eliminate Key Lookups in SQL Server 2008

The Key Lookup operator is a bookmark lookup on a table with a clustered index. Key Lookups can be quite expensive, so you should try to eliminate them when you can. Of course, you should consider your overall workload, and how often the query with the key lookup is executed.… Read more

0 comments, 1,975 reads

Posted in Glenn Berry's SQL Server Performance on 9 June 2010

More Details About Engine Improvements in SQL Server 2008 R2 (SQLTuesday)

This post is for SQLTuesday #007, hosted by Jorge Segarra (blog | twitter). The topic is to talk about your favorite new feature or enhancement in SQL Server 2008 R2. I am going to talk about some of the improvements in the core database engine.

Although the… Read more

1 comments, 859 reads

Posted in Glenn Berry's SQL Server Performance on 8 June 2010

Building an Energy Efficient Workstation

Over this past weekend, I decided to build a new general purpose workstation from parts, with a goal of getting great performance with the lowest power consumption possible. The nice thing about building a Windows based machine is that you can choose the exact components that you want based on… Read more

0 comments, 414 reads

Posted in Glenn Berry's SQL Server Performance on 8 June 2010

3.15Kw Solar PV System in Parker, Colorado

After waiting nearly seven months after I signed the contract, my little 3.15Kw grid-tied solar PV system was partially installed today by Namaste Solar. They could have easily finished it today, but they had to stop so that the city inspector could do an “in progress” inspection on Monday… Read more

0 comments, 602 reads

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

Dachshunds on Patrol

I was home today, since my 3.15Kw solar PV system was being installed, so I took a few pictures of my backyard with my two vicious guard-dog miniature dachshunds, Ruby and Roxy. Ruby (closest to the camera) is ten years old, and Roxy is seven years old. They both weigh… Read more

0 comments, 346 reads

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

SQL Server 2008 and 2008R2 Diagnostic Information Queries for June 2010

This version has updated build lists for SQL Server 2008 and 2008 R2. It also has several new queries, and minor tweaks to many existing queries. Many of these queries will only work on SQL Server 2008 and above. Most of the DMV queries require VIEW SERVER STATE permission.

--…

Read more

3 comments, 1,010 reads

Posted in Glenn Berry's SQL Server Performance on 2 June 2010

Submitted Session Abstracts for PASS Summit 2010

I guess I will join the trend, and list the session abstracts that I submitted for PASS Summit 2010. There is a limit of four session submissions per speaker this year. Hopefully, I will get lucky and will have one or two sessions selected.

DMV Emergency Room!

If you have…

Read more

2 comments, 396 reads

Posted in Glenn Berry's SQL Server Performance on 2 June 2010

Nice Shout-Out From Brad McGehee

I was browsing Twitter today, and I noticed some retweets linking to a blog post that Brad McGehee (blog | twitter) had written called Two Blog Series You Don’t Want to Miss. When I clicked on the link, I saw my smiling mug, along side Paul Randal… Read more

2 comments, 254 reads

Posted in Glenn Berry's SQL Server Performance on 1 June 2010

Troubleshooting Login Failed Errors on SQL Server 2008

While looking over my SQL Server Error logs, I noticed a small flurry of error messages like you see below, every two hours, at the top of the hour:

Login failed for user 'PRODUCTION\SomeSQLAccount'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.xxx.xxx]

Error: 18456, Severity: 14, State: 38.…

Read more

0 comments, 799 reads

Posted in Glenn Berry's SQL Server Performance on 1 June 2010

Microsoft Announces Robotics Developer Studio 2008 R3

Last week, Microsoft released a slightly improved version of Robotics Developer Studio that supports Visual Studio 2010, and adds the functionality of the old Standard Edition of Robotics Developer Studio into one free, integrated package. More details are available at the Microsoft Robotics site. You can use Microsoft Robotics… Read more

0 comments, 571 reads

Posted in Glenn Berry's SQL Server Performance on 1 June 2010