2014-11-28 (first published: 2012-12-06)
16,871 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,013 reads
2009-03-04 (first published: 2009-02-16)
1,241 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,425 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,559 reads
Blogs
The Second Annual, Official WordPress.com Growth Summit is Coming and You Won’t Want to Miss It
By todd-32417
Join us August 17 (Americas) or August 18 (Asia-Pacific). Register today!
The Post Pandemic Office Experience
By Steve Jones
I traveled to Pasadena, CA this week to work with a few other Redgaters...
Connecting to Azure Blobs in Power BI
By DataOnWheels
The step-by-step process below walks through connecting to data housed in Azure Blob Storage...
Forums
Get the last day of the year based on a date range
I am trying to get the last day of the year from a date...
Put two queries together
Hello: Right now I have two queries as shown below: SELECT D.DocumentID AS [Document...
Excel Formula to create SQL Script for a Values Table
Comments posted to this topic are about the item Excel Formula to create SQL...
Ask SSC