2014-11-28 (first published: 2012-12-06)
16,681 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,008 reads
2009-03-04 (first published: 2009-02-16)
1,230 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,420 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,536 reads
Blogs
Graph – Shortest Path
‘Shortest path’ is by far the most feature of SQL Graph for now. What...
Last Week Reading (2019-09-22)
By Kamil
Hello #datafolks! Let’s review what happened last week in Data World. It’s hard to...
Simple Graph Queries
In this post we saw how to create some graph tables with data. In...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
memory not getting released to OS
Hi All, Need help here. Why is sql server is not releasing memory to...
Will the principal wait for acknowledgement from mirror?
Good Morning Experts, A transaction was sent to mirror database and immediately failover occured....
Ask SSC