May 15, 2008 11:00 AM
Posted by: Denny Cherry
Back To Basics,
Message Type,
Service Broker,
SQLThe 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
Posted by: Denny Cherry
Data integrity,
Data Normalization,
SQLBack 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
Posted by: Denny Cherry
Back To Basics,
Service Broker,
SQLThe 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
Posted by: Denny Cherry
SQL,
T/SQL,
xp_fixeddrivesI'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
Posted by: Denny Cherry
ERRORLOG,
sp_who3,
SQLThat "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
April 21, 2008 9:00 AM
Posted by: Denny Cherry
DELETE statement,
SQLWhen 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
Posted by: Denny Cherry
Back To Basics,
sp_change_users_login,
SQLThe 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
Posted by: Denny Cherry
Back To Basics,
Functions,
SQLFunctions 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...
April 10, 2008 8:00 PM
Posted by: Denny Cherry
Back To Basics,
SQL,
SQL Server stored proceduresStored procedures are extremely useful objects. Not only do they store T/SQL scripts for later execution, but they also provide us with an extremely important security barrier between the user interface and the database. The security barrier is used to prevent the users from needing SELECT,...
