Yet Another Deleting Duplicate Records (in-place)
Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column.
2009-01-15 (first published: 2008-12-30)
1,976 reads
Scripts
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,251 reads
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,322 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,227 reads
2009-01-07 (first published: 2008-12-26)
2,150 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,298 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,290 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,521 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,622 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
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Alamat BCA KCP Atrium Telp:08218520154
WhatsApp CS 628218520154 Ruko Atrium Blok E. 12-13, RT.5/RW.18, Sunter Agung, Kec. Tj. Priok,...
Alamat BCA KCP Bungur Telp:08218520154
WhatsApp CS 628218520154 Jl. Bungur Besar Raya No.32 & 32A, RT.3/RW.1, Gn. Sahari Sel.,...
Alamat BCA KCP Cempaka Putih Raya Telp:08218520154
WhatsApp CS 628218520154 Jl. Cempaka Putih Raya No.118 B,C,D, RT.16/RW.3, Cemp. Putih Tim., Kec....
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers