Performs a checkpoint or a transaction log backup followed by a DBCC SHRINKFILE on the transaction log to the target percentage specified relative to the total data file(s) size.
2009-09-23 (first published: 2009-08-27)
This procedure drops all manually added statistics (field user_created=1)
2009-06-11 (first published: 2009-05-25)
The non-SSIS/GUI method I use to deploy standardized Database Maintenance Plans.
2013-05-16 (first published: 2009-05-07)
Compare SQL code of sp, functions, or triggers. Can run across DB and/or servers. Generates report similar to windif. See details in comments
2009-08-03 (first published: 2008-09-05)
Database tables without primary key, clustered index and no index
2008-08-13 (first published: 2008-06-17)
Script to move physical files to a new location
2012-03-30 (first published: 2008-04-21)
Index maintenance procedure using rebuild or reorganized based on fragementation level.
2011-10-26 (first published: 2008-03-28)
How to set the database to a single user mode
2012-07-13 (first published: 2008-03-20)
As per Threshold value DBA will get notified about the Disk Drive usage.
2007-11-23 (first published: 2007-10-08)