SQL Server with Mr. Denny:

SQL


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...


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


April 21, 2008  9:00 AM

Back To Basics: The DELETE Statement



Posted by: Denny Cherry
DELETE statement, SQL

When you have data in your table that you need to remove the DELETE statement is the way to do that.  Using the DELETE statement without any WHERE clause will remove all the data from your table.  The WHERE clause works the same way as the WHERE clause for SELECT and UPDATE...


April 11, 2008  3:00 PM

Back To Basics: How do I use sp_change_users_login?



Posted by: Denny Cherry
Back To Basics, sp_change_users_login, SQL

The sp_change_users_login procedure has a specific purpose.  It's used to identify and correct users within a database which do not have a corresponding logins. You can specify the value of Report for the @Action input parameter to see any users which do not have a corresponding login.  This...


April 11, 2008  5:00 AM

Back To Basics: Functions, the good and the bad



Posted by: Denny Cherry
Back To Basics, Functions, SQL

Functions are create little blocks of code.  They are fantastic for converting data from one format to another, or for looking up other values based on a lookup.  However this comes at a price.  That price is CPU power.  Doing all these additional lookups can cause extra strain on the database...


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: