List All Databases, Sizes and Properties
This script will list all the databases on your server (SQL2000 only) as well as their sizes and some key properties. Very useful for keeping rogue developers under control 🙂
2003-05-17
794 reads
Mike Pearson
Auto Close and Auto Shrink - Just Don't
New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.
2003-05-05
22,279 reads
Get the Foreign Key Hierarchy
This script will run through the foreign keys on tables to produce a hierarchy of the tables in a database.This is useful when you need to purge and repopulate test databases with foreign key contraints
2002-07-24
2,124 reads
List All Jobs and Their Schedules
This queries the sysjobs, sysjobschedules and sysjobhistory table to produce a resultset showing the jobs on a server plus their schedules (if applicable) and the maximun duration of the job.
2002-06-20
4,256 reads
List All Jobs and Their Schedules (SQL7.0 & 2000)
This queries the sysjobs, sysjobschedules and sysjobhistory table to produce a resultset showing the jobs on a server plus their schedules (if applicable).
2002-06-04
1,761 reads
Get table sizes and rowcounts in MB (for VLDB)
This simple script is based on sp_spacedused, but returns values for all user tables in the database, with information in MB instead of the usual KB - which is useful for large databases. Simply run it in query analyser against the database concerned
2002-05-03
756 reads
Blogs
Why I stopped using MCP for AI coding stuff
By HeyMo0sh
Something has shifted quietly in 2026. The developers I know/respect—the ones actually shipping, not...
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers