June 4, 2009 at 7:47 am
Can some give a full explanation the difference between Optimization and Integrity jobs, what is the code to run them?Thank you
June 4, 2009 at 9:50 am
I would define Optimization as jobs that reorganize/rebuild indexes and update statistics.
Integrity Jobs verify that the data on disk is not corrupt. For Integrity things you should read Paul Randal's blog[/url].
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 4, 2009 at 9:54 am
I agree with Jack's list.
ALTER INDEX is typically the first one, DBCC the second. The maintenance plans list these if you walk through the options, it will somewhat explain what each job does.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply