SQL Server with Mr. Denny:

SQL Server 2008


March 12, 2009  11:00 AM

Back To Basics: Reading an Execution Plan



Posted by: Denny Cherry
Back To Basics, Execution Plan, Index Performance, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008

All to often when helping people look at query performance problems I'll ask them to look at the execution plan, and see what it says.  Most query performance problems can be resolved simply by looking at the execution plan and seeing where you need to add an index. All to often I (and others)...

January 22, 2009  3:00 PM

Viewing SQL Server Plan Guides



Posted by: Denny Cherry
Code Snippet, Plan Guides, SQL Server 2005, SQL Server 2008, sys.plan_guides

So you've saved a plan guide into your SQL server, and you want to look at the plan.  You can Query the sys.plan_guides catalog view and see the data exactly as you entered it, which works fine if you just have a hint in there.  But if you have a full XML query plan that isn't going to do you a...


January 7, 2009  11:27 PM

Installing SQL Server 2005 SP3 or SQL Server 2008 on XP Prep SP3 can cause Bug Check



Posted by: Denny Cherry
Bug Check, Microsoft CSS, SQL Server 2005, SQL Server 2008

The SQL Server CSS team has just posted a


December 22, 2008  11:00 AM

Development of SQL 2008 SSIS Packages Requires SSIS Service



Posted by: Denny Cherry
BIDS, SQL Server 2008, SSIS

Unlike in SQL 2005, when developing SSIS packages in SQL Server 2008 BIDS you must have the SSIS service installed on your workstation.  This is a change from SQL Server 2005 where you did not have to have the actual SSIS service installed on your workstation. It doesn't appear that you...


December 8, 2008  1:06 PM

Just how awesome are table parameters in SQL Server 2008?



Posted by: Denny Cherry
CREATE PROCEDURE, SQL Server 2008, T/SQL, Table Variables

I would have to say, that one of the coolest new features of SQL Server 2008 is the ability to pass a table as a single parameter to a stored procedure. While we have been able to do this in the past, by using XML to pass more than one value in, then break it apart. But this is just such a...


December 1, 2008  11:00 AM

SQL Clustering Article in SQL Server Magazine



Posted by: Denny Cherry
Article, Clustering, SQL Server 2005, SQL Server 2008

For those of you who are SQL Server Magazine Subscribers you should be getting your copies right about now (if you haven't already).  When you do be sure to check out the article which I have in the magazine about clustering your SQL Server. For those without a subscription you can sign up for...


November 14, 2008  8:36 PM

Microsoft has released more SQL Server 2008 Exams



Posted by: Denny Cherry
Certifications, SQL Server 2005, SQL Server 2008

Microsoft has now released the the majority of the upgrade exams from SQL Server 2005 to SQL Server 2008.

Continued »


November 6, 2008  11:00 AM

Very useful little query to monitor the health of service broker



Posted by: Denny Cherry
Service Broker, SQL Server 2005, SQL Server 2008, sys.conversation_endpoints

While dealing with a SQL Server Service Broker issue I needed a quick easy way to see how backlogged the service broker was.  So I came up with this little query which is surprisingly effective. select far_service


November 3, 2008  11:00 AM

Improving SQL Service Broker Performance



Posted by: Denny Cherry
END CONVERSATION, RECEIVE, Remus Rusanu, SEND, Service Broker, SQL Server 2005, SQL Server 2008, T/SQL

A while back I was talking to a Microsoft Support Engineer and he had mentioned that in a high load Service Broker environment such as ours there can be some impressive performance improvement can be achieved by reusing the service broker sessions. The cost of creating and closing a new...


October 16, 2008  11:00 AM

Handy Query to look at amount of data in Buffer Cache



Posted by: Denny Cherry
Cache, SQL Server 2005, SQL Server 2008, sys.allocation_units, sys.dm_os_buffer_descriptors, sys.partitions, sys.tables

Here's a handy query which I've written which I've used to see how much of each table is loaded into the SQL Server Buffer Cache.  It shows you how much data is in memory, how much space is used on disk, and the percentage of data in memory compared to the amount of data on disk. SELECT...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: