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,247 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,224 reads
2009-01-07 (first published: 2008-12-26)
2,143 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,295 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,286 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,517 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,619 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
529 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,051 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
Alamat BCA KCP Sopo Del Telp:0821°7555°651
Telp/Wa 62 8217555651 Gedung Sopo Del Office Tower A Lantai GF-15, Jl. Mega Kuningan...
Alamat BCA KCP South Quarter Telp:0821-8200-203
Telp/Wa 62 8218200203 South Quarter Tower, Jl. R.A. Kartini No.Kav. 8 B, Ground Floor...
Alamat BCA KCP Graha Paramita Telp:08218200233
Telp/Wa 62 8218200233 Gdg Graha Paramita Lobby Depan, Jl. Denpasar Raya Blk D-2, RT.7/RW.4,...
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers