Checking free disk space from T/SQL
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. Here is a much, much simpler one.
My ERRORLOG shows some spids have an ‘s’ after them. What’s going on?
Starting in SQL Server 2005 system processes no longer need to run with SPIDs less than 50. Because of this, Microsoft has decided to make live easier when trying to identify the system processes above 50 by putting the s after the SPID number in the logs.
Back To Basics: The DELETE Statement
When you have data in your table that you need to remove the DELETE statement is the way to do that.
New Article: Configure SQL Server Service Broker for sending stored procedure data
I’ve just published a new tip on SearchSQLServer.com called Configure SQL Server Service Broker for sending stored procedure data. In it I’m going over SQL Service Broker and how to configure all the objects.