August 26, 2009 at 1:36 am
what optimisation and integrity job will do in sql ?
August 26, 2009 at 4:56 am
What, just like you have done :-P. there isnt enough detail in your question, what do you want to know exactly and what version of sql server are you using
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
August 26, 2009 at 5:11 am
in general what is the significant of those jobs , using 2000 and 2005.
August 26, 2009 at 5:36 am
ramyours2003 (8/26/2009)
in general what is the significant of those jobs , using 2000 and 2005.
I can only assume that you are talking about the jobs that are created as part of a maintenance plan.
the integrity job runs data integrity checks, which detect corrupted data.
the optimisation job is used to maintain efficient data organization, by allowing indexes to be re-created and reorganised, remove unused space from the database and generally perform changes that will improve general sql performance.
these jobs are normally run overnight or during the weekend.
I hope this helps, if someone else can elaborate more, or link a good article, that might help more.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply