Checking the cached execution plans
We are going to take a look into sys.dm_exec_cached_plans, sys.dm_exec_requests, sys.dm_exec_query_plan, and sys.dm_exec_plan_attributes.
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.