SQL Server with Mr. Denny:

Development


June 2, 2008  11:00 AM

Back To Basics: Service Broker Contracts



Posted by: Denny Cherry
Back To Basics, Contract, Queue, Service Broker, SQL

Every Service Broker conversation requires a contract.  The contract defines which message type or types will be used, as well as who (sender or receiver) can use which message types.  The contract is specified when the conversation is created. The syntax for creating the contract is pretty...

May 26, 2008  11:00 AM

A very strange Service Broker and TempDB problem



Posted by: Denny Cherry
Service Broker, SQL, SQL Server 2005, TempDB

So, a little while ago I was having a major problem at work that I'd like to share in the hopes that someone else finds this information useful. (When I was having this problem, Google wasn't able to find anything for me.) The symptoms that we were having in a nut shell was that the tempdb was...


May 25, 2008  6:25 AM

EMC Posts EMC World Videos on Youtube



Posted by: Denny Cherry
SQL

EMC has posted a bunch of video's from EMC World online for all to see. [kml_flashembed movie="http://www.youtube.com/v/n_SSvKXsgKw" width="425" height="350" wmode="transparent" /] You can see all of

Bookmark and Share     0 Comments     RSS Feed     Email a friend


May 15, 2008  11:00 AM

Back To Basics: Service Broker Message Types



Posted by: Denny Cherry
Back To Basics, Message Type, Service Broker, SQL

The message type is the first of the service broker specific objects.  The message type defines the name of the message, and performs any validation that the service broker needs to do on the contents of the message prior to sending the message.  If the message is being sent to another database...


May 12, 2008  9:00 AM

Data Normalization, with storage being so cheap what’s the point?



Posted by: Denny Cherry
Data integrity, Data Normalization, SQL

Back in the old days one of the big reasons that people enforced such strict rules on data normalization was because it would greatly increase the amount of information you could fit on the hard drive.  Back when everything was measured in kilobytes or megabytes storing redundant information...


May 8, 2008  11:00 AM

Back To Basics: The SQL Server Service Broker



Posted by: Denny Cherry
Back To Basics, Service Broker, SQL

The SQL Server Service Broker is a fantastic new addition to SQL Server.  For those who have used Microsoft Message Queue (MSMQ) the service broker will be easy to understand as it's the same basic concept.  Messages are sent from one place to another, within a database, from database to...


May 5, 2008  9:00 AM

I’ll be speaking at the Inland Empire .Net User Group



Posted by: Denny Cherry
In Person Events, Query tuning, Resource Governor

The nice folks at the Inland Empire .NET User Group have invited me to come and speak to them.  This is a great speaking opportunity for me as they are about 20 minutes from my house. I won't be speaking there until...


May 1, 2008  9:00 AM

Checking the cached execution plans



Posted by: Denny Cherry
Cache, Execution Plan, Query tuning, SQL Server 2005, sys.dm_exec_cached_plans, sys.dm_exec_plan_attributes, sys.dm_exec_query_plan, sys.dm_exec_requests

As we all know SQL Server, will for good or bad, cache execution plans.  Up until now it's been very tough to see the cached execution plans.  You pretty much had to grab the query or procedure (with the parameters) and run it with Query Analyzer and have it return the execution plan.  The only...


April 28, 2008  9:00 AM

Checking free disk space from T/SQL



Posted by: Denny Cherry
SQL, T/SQL, xp_fixeddrives

I've seen some very creative ways to see how much free disk space SQL Servers have.  Most make use of xp_cmdshell which some very complex dos commands or vbscripts. However there is a much easier way.  Microsoft has included the system extended stored procedure xp_fixeddrives.  It returns the...


April 24, 2008  12:23 PM

My ERRORLOG shows some spids have an ‘s’ after them. What’s going on?



Posted by: Denny Cherry
ERRORLOG, sp_who3, SQL

That "s" is new in SQL Server 2005.  It means that the SPID is a system process.  For example my database is having a problem with tempdb running out of space for no reason.  When I look in the log I see that SPID 118s is the offending SPID.  When I watch SPID 118 using

Bookmark and Share     0 Comments     RSS Feed     Email a friend


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: