Monthly Archives: July 2009

The Effect of Data Access Code On SQL Server Performance

Posted on July 31, 2009 by Glenn Berry

Bob Beaucheamin, who works at SQLSkills, has an excellent new article in MSDN Magazine that explains how different methods of writing data access code in ADO.NET can have a huge effect on performance and security. Here is the executive summary … Continue reading →

Posted in SQL Server 2008 | 33 Comments

Nice Mention On SQL Server Central

Posted on July 30, 2009 by Glenn Berry

I just discovered that Andy Warren of SQL Server Central has chosen me as “Featured Blogger”, with some very kind words about my blog. Thanks, Andy, I really appreciate it!

Posted in SQL Server 2008 | 6 Comments

How To Get SQL Server CPU Utilization From a Query

Posted on July 30, 2009 by Glenn Berry

I like to use DMV and other T-SQL queries to quickly and easily get information about how my database servers are running. I have written, used, and shared many useful queries for finding out quite a bit about what was … Continue reading →

Posted in SQL Server 2008 | 7 Comments

How Much Space Does My Database Use?

Posted on July 28, 2009 by Glenn Berry

Since I have been spending some time cleaning up some databases in preparation for some server consolidation work, I thought I would share some useful queries for determining things like how large your database is, how full the files are, … Continue reading →

Posted in SQL Server 2008 | 32 Comments

SQL Server 2008 SP1 Cumulative Update 3

Posted on July 21, 2009 by Glenn Berry

Microsoft  has released SQL Server 2008 SP1 CU3 and SQL Server 2008 RTM CU6, both of which have lots of fixes. SP1 CU3 is Build 2723 and RTM CU6 is Build 1812. Microsoft continues to do a good job of … Continue reading →

Posted in SQL Server 2008 | 15 Comments

When Can You Get The Windows 7 RTM Bits?

Posted on July 21, 2009 by Glenn Berry

One of the recent outstanding questions among Microsoft enthusiasts has been when exactly we could get our hands on the official, final RTM bits for Windows 7. Well, now we know, straight from this post from Microsoft’s Brandon Leblanc on … Continue reading →

Posted in Microsoft | 10 Comments

Some Useful Full Text Index Stoplist Related Queries

Posted on July 21, 2009 by Glenn Berry

Stoplists are used in SQL Server Full Text Indexes to exclude common “noise” words (such as to, the, etc.) from filling up the index with information that is not very useful for Full Text Searches. By default, a new Full … Continue reading →

Posted in SQL Server 2008 | 20 Comments

Finding Dead Objects in SQL Server 2008

Posted on July 20, 2009 by Glenn Berry

I have been doing some house cleaning on my databases, looking for stored procedures that are no longer used by any of our applications. I’m not using any fancy third party tools, just what I think is a little common … Continue reading →

Posted in SQL Server 2008 | 17 Comments

Denver and Boulder SQL Server User’s Group Meetings

Posted on July 14, 2009 by Glenn Berry

The Boulder SQL Server User’s Group (BSSUG) is meeting tonight starting at 5:30PM in Broomfield. I will be giving my “Using SQL Server 2008 Database Mirroring to Become a Super Hero!” presentation and demo at 7:00PM, after Peter Myer’s presentation … Continue reading →

Posted in SQL Server 2008 | 5 Comments

SQL Server 2008 Failover Clustering Whitepaper

Posted on July 10, 2009 by Glenn Berry

The busy people at SQLCAT have released another whitepaper, this time on SQL Server 2008 Failover Clustering. This is quite a long document at 175 pages, but it is packed with useful information. Failover clustering is a tested and reliable … Continue reading →

Posted in SQL Server 2008 | 1 Comment