SQL Server with Mr. Denny:

ITKE grandparent


October 31, 2007  6:09 AM

What is Service Broker?

Denny Cherry Denny Cherry Profile: Denny Cherry
i5, Migration

Service Broker is a transaction message queueing system build into Microsoft SQL Server.  It provides you with in order, guaranteed single read, message processing that is handled and managed with T/SQL code.  This makes it extremely easy to send and process messages either within a single...

October 29, 2007  8:00 AM

Easy way to read XML execution plans.

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Take your XML execution plan and save it to a file with a file extension of sqlplan (such as MyQuery.sqlplan) and double click on it.  It will open in the SQL Server Management Studio and show you the plan in the GUI plan viewer making it much easier to read than the XML version.

    0 Comments     RSS Feed     Email a friend


October 24, 2007  5:09 AM

Upgrade for sp_who2 called sp_who3

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I've published this before over on tek-tips.com, but I figured that I'd republish it here as well.  I've written an update for sp_who2 which I call sp_who3.  It can be most useful when trying to diagnose slow running queries as it can provide a wealth of information in a single...


October 17, 2007  5:46 PM

What does the min server memory setting actually mean?

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I know that there is some confusion about what exactly the minimum server memory setting...


October 15, 2007  6:54 PM

Better Error Reporting for Service Broker

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I've submitted a request to Microsoft (via the Connect site) to have them improve the error reporting which the Service Broker does to the error log.  If everyone could vote for that submission (

    0 Comments     RSS Feed     Email a friend


October 10, 2007  1:58 AM

Getting the right disk config for your SQL Server

Denny Cherry Denny Cherry Profile: Denny Cherry
i5, Migration

Many DBAs so not have the knowledge needed in the storage area to be able to ask the right questions to there storage engineers, and often storage engineers do not know the right...


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: