Monthly Archives: March 2015

Database Restores – Zeroing Out Log Files

A look at what happens the log file when the database is restored. Continue reading

Posted in Administration, Internals | Tagged , | Leave a comment

Quick Script: Finding Columns

A T-SQL script that I wrote to hunt for certain columns based off their names. Continue reading

Posted in T-SQL | Tagged , | Leave a comment

SQL Saturday 381 – Richmond, VA

A brief look at the presentation I’ll be giving at SQL Saturday 381 in Richmond, VA. Continue reading

Posted in Community, Presenting, SQL Saturday | Tagged , , | Leave a comment

Quick Script: Dropping Indexes

A quick script that was written to drop all non-clustered indexes from a database to reduce space. The script also handles XML indexes. Continue reading

Posted in Indexes | Tagged | 4 Comments