Monthly Archives: March 2015
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
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
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
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