The following script will allow the user to get information from all spids that have a program name associated with them. That is event info out of dbcc inputbuffer. Additional columns may be added and used in the table through simple modifications of the script. I just found it useful for troubleshooting and setting up […]
2006-10-19 (first published: 2006-09-29)
2,145 reads
By DataOnWheels
A little over a month ago, Pragmatic Works Consulting was a part of a...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...
I want to call (REST) API the "GET" command and assign the return value...
I deleted few tables having millions of records, but when see the physical space,...
I want all these description in different row. TIA Example descriptions 0|Home 1|Office|False...
Ask SSC