Maintenance Plan Archives - Page 4 of 4 - SQL Authority with Pinal Dave

This month's discount Comprehensive Database Performance Health Check Testimonials

Home

A half-knitted cream scarf resting on an armchair with its needles, a red ball of yarn beside it ready to continue.

Rebuild Index Quiz: DROP and CREATE, DROP_EXISTING or REBUILD?

January 22, 2012

Pinal Dave

SQL Puzzle

Maintenance Plan, SQL Index, SQL Performance, SQL Table Operation

This Rebuild Index Quiz asks which way of refreshing an index stays usable and can pause and resume. The answer is ALTER INDEX with ONLINE and RESUMABLE turned on. A tested two-window script shows the pause and the resume.

A garden of perfectly clipped square hedges, while one overgrown apple tree in the corner stands unpruned.

Index Maintenance on Modern Storage

July 31, 2007

Pinal Dave

SQL Performance

DBA, Maintenance Plan, SQL Data Storage, SQL Index, SQL Statistics

Index maintenance on modern storage needs query evidence, page density, and statistics checks before you choose a rebuild or lighter action.