Cluster Information
This script will display information about the instance(s) on your cluster. Name of nodes, active node and drive letters of the resources
2009-05-08 (first published: 2009-04-15)
1,431 reads
Scripts
2009-05-07 (first published: 2009-03-27)
1,617 reads
Convert GMT/UTC to Local datetime
International Applications require timezone handling for different users Here is how to do this with SQL.
2009-05-06
4,180 reads
Easily calculate the size of your tables
This quick and dirty sql will tell you the number of rows in your tables, the size in MB of yout data, and the total size (including indexes)
2009-05-04 (first published: 2008-10-04)
1,697 reads
What SQL JOb's are running on 2005 Server
This script returns the information of all SQL Jobs that are running on the server with the latest status.
2009-05-01 (first published: 2009-04-08)
1,644 reads
Check if a sql server agent job ran
Checks if a sql server job ran successfully in the last xx minutes.
2009-04-29 (first published: 2009-04-02)
1,468 reads
2009-04-28
2,397 reads
usp_SQL_In_sp_who2
Ammends the sp_who2 procedure with the input buffer contents, ususally the SQL statement for that SPID
2009-04-24 (first published: 2009-03-27)
1,311 reads
2009-04-22 (first published: 2009-03-19)
1,068 reads
Check Syntax on a Database
This script finds the first error on all Sprocs, Functions, Triggers and Views in a database. Works in SQL Server 2005 and 2008
2009-04-21 (first published: 2009-03-26)
909 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Designing for Teams
Comments posted to this topic are about the item Designing for Teams
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers