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.
Indexes & Snapshots On February 24, 2014February 23, 2014 By John Morehouse A test to see if index fragmentation is carried into a database snapshot.
Throw more wood on the fire! On February 1, 2011January 30, 2011 By John Morehouse A brief thought as to why adding more rows to a table gave me my expected results in the execution plan. Namely, a key lookup.