2014-11-28 (first published: 2012-12-06)
16,842 reads
Eric Wahner
Procedure Class Generator
Dynamically creates a VB.NET class from parameters in a SQL Stored procedure.
2009-03-09 (first published: 2009-02-16)
1,012 reads
2009-03-04 (first published: 2009-02-16)
1,240 reads
Who's Blocking
A quick little standalone script that tells you what process is blocking and what processes the blocking processing actually blocking.When running this script in QA, change your output to "Results in Text" ( CTRL-T ). Utilizes the blocking info in sp_who2 combined with dbcc inputbuffer and a little cursor to wrap it all up. Formatting […]
2007-04-19 (first published: 2007-03-20)
7,424 reads
What's Running
spWhatsRunning does just that. It tells you exactly what is executing on your server. By combining the output of the sp_who and dbcc inputbuffer, this script will tell you exactly whats being executed. DBCC INPUTBUFFER will tell you the same thing, but by the time you get the spid, the offending process may be gone. […]
2007-04-17 (first published: 2007-03-20)
2,557 reads
Blogs
Basic XML Queries–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Don’t Stop at Just Enabling Read Committed Snapshot Isolation (RCSI)
By kleegeek
This past week I had a great Client ask an even greater question, and...
Query Compile Time
A question that came up recently was how to track the query compile time....
Forums
Cannot attach database after new additional instance installation on sql server
Locate database files did not get out any .mdf file, even though there is...
SELECT column based on parameter
Is there a way in the same SELECT statement to show different columns without...
Restore WITH RECOVERY freezing on source DB after tail of log backup
Hello everyone, I've encountered this scenario twice so far and I still don't understand...
Ask SSC