Find database file reamaining growth
This script is used for SQL Server 2000 Database file remaining growth. This script is little bit modified to fit SQL Server 2000.
2009-01-14 (first published: 2009-01-03)
1,244 reads
Scripts
Indepth SPID information
This SP gives you most of the detail you need on a long running query. Simply pass the SPID.
2009-01-09 (first published: 2008-12-31)
2,315 reads
Complete Blocking Report
A complete blocking report which gives the complete information about what queries are runninng and it will be worth capturing the details before we decide to kill the processes.
2009-01-08 (first published: 2008-12-26)
2,222 reads
2009-01-07 (first published: 2008-12-26)
2,142 reads
Object Search for Sql Server 2005
This script will search databases, tables, columns, stored procedures for text.
2009-01-05 (first published: 2008-12-21)
1,294 reads
Getting unique or primary key columns for a given table
Following script will list out all the columns which have unique/primary key constraints for a given table.
2009-01-02 (first published: 2008-12-10)
1,285 reads
Deleting old files (with/without archive bit)
A hopefully useful script to delete old files, not just backups, and make use of the archive bit.
2009-01-01 (first published: 2008-12-09)
2,513 reads
Automatically Restore Backup Files for SQL 2005
This script helps with restoring backup files SQL Server 2005
2008-12-31 (first published: 2008-12-11)
1,617 reads
Insert Multiple Records using a Single insert statement
This is used to insert the multiple values using a single insert statment.
2008-12-31
527 reads
Tables referenced by a stored proc (2000)
This should find all tables referenced by an sp. It uses syscomments and hence has a wrap 'issue'.
2008-12-30 (first published: 2008-12-05)
1,049 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Alamat BCA KCP Pasar Telp:08218200203
WA CS 628218200203 Komp. Cipulir Permai, E Jl. Ciledug Raya No.9, RT.9/RW.5, Ulujami, Kec....
Alamat BCA KCP Manhattan Telp/Wa:0821-8200-203
Hub CS 08218200203 The Manhattan Square, Mid. Tower, Lt. Ground Unit A & Lt....
Alamat BCA KCP Mal Pondok Indah Telp:0821-8200-203
Telp/Wa 62 8218200203 Ground Floor G31 & G32, Jl. Metro Pondok Indah, RT.1/RW.16, Pd....
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers