Category Archives: Alphabetical

“Create Object Statement Builder” Tool for SQL Server 2005

Scenario: You’ve identified unused indexes to remove from your production system. However, for thoroughness, you want to create a rollback script to restore the removed indexes. You have a couple of options to create such a script: 1. If you … Continue reading

Posted in Alphabetical, DBA Best Practice, DBA Tools | Tagged , , , , , , , , | Comments Off on “Create Object Statement Builder” Tool for SQL Server 2005

“Database Mail Replication” Tool for SQL Sever 2005

Scenario: You have a SQL Server 2005 instance configured with Database Mail. However, you need to activate and configure Database Mail for several other instances. Or perhaps you’d like to standardize the database-mail account and profile attributes across several instances. … Continue reading

Posted in Alphabetical, DBA Tools | Tagged , , | Comments Off on “Database Mail Replication” Tool for SQL Sever 2005

“Email SQL Server Errors” Tool for SQL Server 2005

Scenario: You want the skinny on your SQL Server error log. That is, you don’t want to skim hundreds of lines for possible embedded errors (“Error Log,” after all, is a bit of a misnomer as this file holds much … Continue reading

Posted in Alphabetical, DB Mail, DBA Best Practice, DBA Tools | Tagged , , , , , | Comments Off on “Email SQL Server Errors” Tool for SQL Server 2005

“Get DBCC CHECKDB Output” Tool for SQL Server 2005

Scenario: You’d like to automate the invocation of DBCC CHECKDB to validate the structural integrity of your databases. Solution: The below script Executes DBCC CHECKDB against all SQL Server databases except TempDB Captures the DBCC CHECKDB output into a work table Identifies the summary … Continue reading

Posted in Alphabetical, DB Mail, DBA Best Practice, DBA Tools, DBCC | Tagged , , , , | Comments Off on “Get DBCC CHECKDB Output” Tool for SQL Server 2005

“Get Unused Index Deletion Candidates” Tool for SQL Server 2005

Scenario: In the “Get Unused Indexes” Tool for SQL Server 2005 post, I presented a script to capture unused indexes for a given database. Specifically, I capture “unused index” information in the DBA.dbo.UnusedIndexes table. After we collect several days of … Continue reading

Posted in Alphabetical, DBA Best Practice, DBA Tools, Performance Tuning | Tagged , , , , | Comments Off on “Get Unused Index Deletion Candidates” Tool for SQL Server 2005