Tag Archives: Indexes

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

Indexes & Snapshots

A test to see if index fragmentation is carried into a database snapshot. Continue reading

Posted in Indexes, Snapshots | Tagged , , | 7 Comments

Throw more wood on the fire!

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. Continue reading

Posted in Indexes | Tagged , | 1 Comment