jobs

  • what optimisation and integrity job will do in sql ?

  • Why did you post the same question 4 times.! ?

    Please don't do that. Post only once and wait for the responses.

  • If you are referring to the maintenance jobs then start woth BOL (books on line) The help feature is very useful.

    see ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/c7a3932e-e6ab-4cc2-8664-e0284490b898.htm

    and

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/ad879ed6-223a-4a06-a459-8c2ca25ce92d.htm

    Personally I don't use maintenance plans at all. I prefer to create my own maintenance jobs so I know exactly what is being done and I can more closely control what is happening. For axample, why reindex all indexes if only some subset requires it. I'd rather search for indexes on large tables (where I define what is a large table) and only reindex those as opposed to reindexing everything. Or else only reindex if the some threshold is exceded. This is more important on a large database because for a very small database it may take very little time and resources to just do it all. The maintenance plans can be useful and there is a help button available. With SQL 2005 you can generate the T_SQL code that goes along with the maintenace plan so it is easier to understand what is happening

    Francis

  • If you don't know what you're doing, the maintenance plans work great. However please read the documentation a little before posting.

    If you understand them, as Francis mentioned, there are better ways to do things if you are willing to script a little. We have a number of maintenance scripts on this site that will reindex/rebuild only those indexes that need it.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply