Hey, Sorry for the long delay in posts, the usual, life getting in the way! But I recently had what to me seemed an obscure problem (although in hindsight, duh), but turned out to be caused by out of date statistics (Big thanks to Brent Ozar for the assist twitter | blog). The Problem To […]
Today we’ll do the 4th and final part of the Maintenance Plan Wizard, which covers Backups and keeping your hard disks clean! Back Up Database (Full)The jobs get more obvious as they go on, making my explanations a bit easier! This takes a full copy of your database and dumps it to a file (usually
Introduction to the Maintenance Plan Wizard – Part 4 Read More »
Today I’m going to move on to part 3 (of 4) of explaining the Maintenance Plan Wizard. Here’s a picture of the layout again, just in case you forgot!So today we’ll start with:Update StatisticsSo first, what are statistics. Statistics are SQL Servers internal information which it uses to make sure that your Query Plans are
Introduction to the Maintenance Plan Wizard – Part 3 Read More »
Woo, 2 in a row! Today I’ll be doing the second part of walking through the Maintenance Plan Wizard, Re-Organizing and Re-Building indexes. Reorganize IndexAgain, does what it says on the tin. This task kicks off an “Alter index REORGANIZE” for all the indexes in your database. It moves around the data in your index
Introduction to the Maintenance Plan Wizard – Part 2 Read More »
Hey, Sorry for the sporadic posts, planning a wedding and blogging do not necessarily go hand in hand! Anyway, moving on, I’m putting together a presentation for the Reluctant DBA, and part of it will be on the Maintenance plan wizard, and how it is the (slightly blunt) swiss army knife for the DBA with
Introduction to the Maintenance Plan Wizard – Part 1 Read More »
