2009-01-17 (first published: 2008-05-28)
2,827 reads
2009-01-17 (first published: 2008-05-28)
2,827 reads
2009-01-16 (first published: 2009-01-03)
2,579 reads
Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column.
2009-01-15 (first published: 2008-12-30)
1,906 reads
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,213 reads
This SP gives you most of the detail you need on a long running query. Simply pass the SPID.
2009-01-12 (first published: 2008-12-31)
2,113 reads
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,177 reads
2009-01-07 (first published: 2008-12-26)
2,104 reads
A hopefully useful script to delete old files, not just backups, and make use of the archive bit.
2009-01-02 (first published: 2008-12-09)
2,112 reads
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,255 reads
This script helps with restoring backup files SQL Server 2005
2008-12-31 (first published: 2008-12-11)
1,594 reads
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers