Monthly Archives: March 2015

Quickly output a stored proc to Excel with SQLCMD

Now XP_CMDSHELL raises one too many red flags, and we dont encourage its use. But lets not forget the trusty ol’ tool that we have : SQLCMD. Try the following line to get the output of the proc to a … Continue reading

Posted in Uncategorized | Leave a comment

Extended Events : Why is “retrieving event information from server” empty ?

Extended Events is a very powerful new feature of SQL Server 2012. The best thing about this is that its so powerful, yet very lightweight (in terms of resource utilization) and extremely easy to set up and use. Except for … Continue reading

Posted in Uncategorized | Leave a comment

Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Ok, this is usually seen when reading Job history details through SSMS. So what are your options? One way is to go and see how many records you have in the history table. It is usually safe to remove some … Continue reading

Posted in Uncategorized | 1 Comment

Find blocking query details from sysprocesses, including text, host, time, etc

Here is a query that I wrote to find details of the blocked queries : SELECT — Get Blocked details : ‘spid ‘ + cast(A.spid as varchar(100))       + ‘ is being blocked by spid ‘ + cast(A.blocked as varchar(100)) … Continue reading

Posted in Uncategorized | Leave a comment