This script will provide a dynamic mechanism to decide between REBUILDING an index or simply REORGANIZING an index. Tested and approved for SQL Server 2005 & 2008 Standard or Enterprise or R2.
2012-11-26 (first published: 2012-10-18)
3,419 reads
This script will produce the top 10 wait state issues along with their descriptions.
2012-11-22 (first published: 2012-10-22)
1,737 reads
Backup up all databases based on sys.databases.
2012-11-21 (first published: 2012-10-02)
1,431 reads
Backup up all transaction logs based on sys.databases.
2012-11-16 (first published: 2012-10-02)
1,092 reads
Constructs a restore script for all databases on the server from backup history.
2012-11-12 (first published: 2012-09-26)
1,209 reads
Find all columns containing a string value across all tables and schemas.
2012-11-07 (first published: 2012-10-12)
1,853 reads
It shrinks all log files for the databases created by users.
2012-11-02 (first published: 2012-09-27)
3,790 reads
Last Time a Table Accessed with Create and Modify Date.
2012-10-30 (first published: 2012-10-12)
2,275 reads
This stored procedure helps you list all tables, stored procedures, functions, view and triggers in a database.
2012-10-29 (first published: 2012-10-03)
1,849 reads
C# CLR routine to convert the pwdLastSet attribute to DateTime
2012-10-26 (first published: 2012-10-02)
825 reads