Database Restores – Zeroing Out Log Files On March 26, 2015March 24, 2015 By John Morehouse A look at what happens the log file when the database is restored.
Quick Script: Finding Columns On March 19, 2015March 18, 2015 By John Morehouse A T-SQL script that I wrote to hunt for certain columns based off their names.
SQL Saturday 381 – Richmond, VA On March 12, 2015March 12, 2015 By John Morehouse A brief look at the presentation I’ll be giving at SQL Saturday 381 in Richmond, VA.
Quick Script: Dropping Indexes On March 5, 2015March 16, 2015 By John Morehouse A quick script that was written to drop all non-clustered indexes from a database to reduce space. The script also handles XML indexes.