I've set up a Database Maintenance Plan that Checks Database Integrity,
Reorganizes Index, Rebuilds Index, Update Statistics and Cleans Up History.
If I set the plan to perform these tasks on either All Databases or All User
Databases, will new databases be detected? Or would I need to recreate the
plan any time a new database is added?
You'll need to modify your maintanence plan to include the new ones. They'll
not be added to your old plan automatically.
However, performing all these jobs (I don't know your schedule however
something makes me think it's everyday) may not be appropriate for every
environment.
It's also not a good idea to include all of these jobs only in one plan as
one of these jobs would fail, the others after that failed one would not
work.
Ekrem ?nsoy
"cc.shine" <cc.shine@.discussions.microsoft.com> wrote in message
news:0011FCDF-395D-4F01-912C-90C189011EBD@.microsoft.com...
> I've set up a Database Maintenance Plan that Checks Database Integrity,
> Reorganizes Index, Rebuilds Index, Update Statistics and Cleans Up
> History.
> If I set the plan to perform these tasks on either All Databases or All
> User
> Databases, will new databases be detected? Or would I need to recreate
> the
> plan any time a new database is added?
|||Actually Ekrem .. I found maintenance plans pick up new databases without any
issue without me having to recreate it in 2000 and 2005. But then again I
only use that for backing up ;-).
I have found if I change the maintenace plan name after created it onces,
the jobs don't updated properly. And if I add new tasks then they don't get
reflected properly; but for backups it's been good but it's the nightly full
backups only.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Ekrem ?nsoy" wrote:
> You'll need to modify your maintanence plan to include the new ones. They'll
> not be added to your old plan automatically.
> However, performing all these jobs (I don't know your schedule however
> something makes me think it's everyday) may not be appropriate for every
> environment.
> It's also not a good idea to include all of these jobs only in one plan as
> one of these jobs would fail, the others after that failed one would not
> work.
> --
> Ekrem ?nsoy
>
> "cc.shine" <cc.shine@.discussions.microsoft.com> wrote in message
> news:0011FCDF-395D-4F01-912C-90C189011EBD@.microsoft.com...
>
|||Actually, it would be the most correct to say new databases would be
included automatically if you do not choose particular databases from the
list and choose All User Databases =)
Ekrem ?nsoy
"Mohit K. Gupta" <mohitkgupta@.msn.com> wrote in message
news:09E5DB39-C9E5-4D2D-BBF1-AB5303143EFC@.microsoft.com...[vbcol=seagreen]
> Actually Ekrem .. I found maintenance plans pick up new databases without
> any
> issue without me having to recreate it in 2000 and 2005. But then again I
> only use that for backing up ;-).
> I have found if I change the maintenace plan name after created it onces,
> the jobs don't updated properly. And if I add new tasks then they don't
> get
> reflected properly; but for backups it's been good but it's the nightly
> full
> backups only.
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
> "Ekrem ?nsoy" wrote:
Showing posts with label statistics. Show all posts
Showing posts with label statistics. Show all posts
Sunday, March 11, 2012
Database Maintenance Plans
I've set up a Database Maintenance Plan that Checks Database Integrity,
Reorganizes Index, Rebuilds Index, Update Statistics and Cleans Up History.
If I set the plan to perform these tasks on either All Databases or All User
Databases, will new databases be detected? Or would I need to recreate the
plan any time a new database is added?You'll need to modify your maintanence plan to include the new ones. They'll
not be added to your old plan automatically.
However, performing all these jobs (I don't know your schedule however
something makes me think it's everyday) may not be appropriate for every
environment.
It's also not a good idea to include all of these jobs only in one plan as
one of these jobs would fail, the others after that failed one would not
work.
--
Ekrem Ã?nsoy
"cc.shine" <cc.shine@.discussions.microsoft.com> wrote in message
news:0011FCDF-395D-4F01-912C-90C189011EBD@.microsoft.com...
> I've set up a Database Maintenance Plan that Checks Database Integrity,
> Reorganizes Index, Rebuilds Index, Update Statistics and Cleans Up
> History.
> If I set the plan to perform these tasks on either All Databases or All
> User
> Databases, will new databases be detected? Or would I need to recreate
> the
> plan any time a new database is added?|||Actually Ekrem .. I found maintenance plans pick up new databases without any
issue without me having to recreate it in 2000 and 2005. But then again I
only use that for backing up ;-).
I have found if I change the maintenace plan name after created it onces,
the jobs don't updated properly. And if I add new tasks then they don't get
reflected properly; but for backups it's been good but it's the nightly full
backups only.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Ekrem Ã?nsoy" wrote:
> You'll need to modify your maintanence plan to include the new ones. They'll
> not be added to your old plan automatically.
> However, performing all these jobs (I don't know your schedule however
> something makes me think it's everyday) may not be appropriate for every
> environment.
> It's also not a good idea to include all of these jobs only in one plan as
> one of these jobs would fail, the others after that failed one would not
> work.
> --
> Ekrem Ã?nsoy
>
> "cc.shine" <cc.shine@.discussions.microsoft.com> wrote in message
> news:0011FCDF-395D-4F01-912C-90C189011EBD@.microsoft.com...
> > I've set up a Database Maintenance Plan that Checks Database Integrity,
> > Reorganizes Index, Rebuilds Index, Update Statistics and Cleans Up
> > History.
> > If I set the plan to perform these tasks on either All Databases or All
> > User
> > Databases, will new databases be detected? Or would I need to recreate
> > the
> > plan any time a new database is added?
>|||Actually, it would be the most correct to say new databases would be
included automatically if you do not choose particular databases from the
list and choose All User Databases =)
--
Ekrem Ã?nsoy
"Mohit K. Gupta" <mohitkgupta@.msn.com> wrote in message
news:09E5DB39-C9E5-4D2D-BBF1-AB5303143EFC@.microsoft.com...
> Actually Ekrem .. I found maintenance plans pick up new databases without
> any
> issue without me having to recreate it in 2000 and 2005. But then again I
> only use that for backing up ;-).
> I have found if I change the maintenace plan name after created it onces,
> the jobs don't updated properly. And if I add new tasks then they don't
> get
> reflected properly; but for backups it's been good but it's the nightly
> full
> backups only.
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
> "Ekrem Ã?nsoy" wrote:
>> You'll need to modify your maintanence plan to include the new ones.
>> They'll
>> not be added to your old plan automatically.
>> However, performing all these jobs (I don't know your schedule however
>> something makes me think it's everyday) may not be appropriate for every
>> environment.
>> It's also not a good idea to include all of these jobs only in one plan
>> as
>> one of these jobs would fail, the others after that failed one would not
>> work.
>> --
>> Ekrem Ã?nsoy
>>
>> "cc.shine" <cc.shine@.discussions.microsoft.com> wrote in message
>> news:0011FCDF-395D-4F01-912C-90C189011EBD@.microsoft.com...
>> > I've set up a Database Maintenance Plan that Checks Database Integrity,
>> > Reorganizes Index, Rebuilds Index, Update Statistics and Cleans Up
>> > History.
>> > If I set the plan to perform these tasks on either All Databases or All
>> > User
>> > Databases, will new databases be detected? Or would I need to recreate
>> > the
>> > plan any time a new database is added?
Reorganizes Index, Rebuilds Index, Update Statistics and Cleans Up History.
If I set the plan to perform these tasks on either All Databases or All User
Databases, will new databases be detected? Or would I need to recreate the
plan any time a new database is added?You'll need to modify your maintanence plan to include the new ones. They'll
not be added to your old plan automatically.
However, performing all these jobs (I don't know your schedule however
something makes me think it's everyday) may not be appropriate for every
environment.
It's also not a good idea to include all of these jobs only in one plan as
one of these jobs would fail, the others after that failed one would not
work.
--
Ekrem Ã?nsoy
"cc.shine" <cc.shine@.discussions.microsoft.com> wrote in message
news:0011FCDF-395D-4F01-912C-90C189011EBD@.microsoft.com...
> I've set up a Database Maintenance Plan that Checks Database Integrity,
> Reorganizes Index, Rebuilds Index, Update Statistics and Cleans Up
> History.
> If I set the plan to perform these tasks on either All Databases or All
> User
> Databases, will new databases be detected? Or would I need to recreate
> the
> plan any time a new database is added?|||Actually Ekrem .. I found maintenance plans pick up new databases without any
issue without me having to recreate it in 2000 and 2005. But then again I
only use that for backing up ;-).
I have found if I change the maintenace plan name after created it onces,
the jobs don't updated properly. And if I add new tasks then they don't get
reflected properly; but for backups it's been good but it's the nightly full
backups only.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Ekrem Ã?nsoy" wrote:
> You'll need to modify your maintanence plan to include the new ones. They'll
> not be added to your old plan automatically.
> However, performing all these jobs (I don't know your schedule however
> something makes me think it's everyday) may not be appropriate for every
> environment.
> It's also not a good idea to include all of these jobs only in one plan as
> one of these jobs would fail, the others after that failed one would not
> work.
> --
> Ekrem Ã?nsoy
>
> "cc.shine" <cc.shine@.discussions.microsoft.com> wrote in message
> news:0011FCDF-395D-4F01-912C-90C189011EBD@.microsoft.com...
> > I've set up a Database Maintenance Plan that Checks Database Integrity,
> > Reorganizes Index, Rebuilds Index, Update Statistics and Cleans Up
> > History.
> > If I set the plan to perform these tasks on either All Databases or All
> > User
> > Databases, will new databases be detected? Or would I need to recreate
> > the
> > plan any time a new database is added?
>|||Actually, it would be the most correct to say new databases would be
included automatically if you do not choose particular databases from the
list and choose All User Databases =)
--
Ekrem Ã?nsoy
"Mohit K. Gupta" <mohitkgupta@.msn.com> wrote in message
news:09E5DB39-C9E5-4D2D-BBF1-AB5303143EFC@.microsoft.com...
> Actually Ekrem .. I found maintenance plans pick up new databases without
> any
> issue without me having to recreate it in 2000 and 2005. But then again I
> only use that for backing up ;-).
> I have found if I change the maintenace plan name after created it onces,
> the jobs don't updated properly. And if I add new tasks then they don't
> get
> reflected properly; but for backups it's been good but it's the nightly
> full
> backups only.
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
> "Ekrem Ã?nsoy" wrote:
>> You'll need to modify your maintanence plan to include the new ones.
>> They'll
>> not be added to your old plan automatically.
>> However, performing all these jobs (I don't know your schedule however
>> something makes me think it's everyday) may not be appropriate for every
>> environment.
>> It's also not a good idea to include all of these jobs only in one plan
>> as
>> one of these jobs would fail, the others after that failed one would not
>> work.
>> --
>> Ekrem Ã?nsoy
>>
>> "cc.shine" <cc.shine@.discussions.microsoft.com> wrote in message
>> news:0011FCDF-395D-4F01-912C-90C189011EBD@.microsoft.com...
>> > I've set up a Database Maintenance Plan that Checks Database Integrity,
>> > Reorganizes Index, Rebuilds Index, Update Statistics and Cleans Up
>> > History.
>> > If I set the plan to perform these tasks on either All Databases or All
>> > User
>> > Databases, will new databases be detected? Or would I need to recreate
>> > the
>> > plan any time a new database is added?
Thursday, March 8, 2012
Database Maintenance Plan
Hi,
Please tell me why isn't it possible to switch in one maintenance plan
Reorganize data and index pages and Update the statistics used by the query
optimizer?
May be reorganizing data and indexes also updates statistics? but if yes,
updates it all statistics or only some of them?
Thanks
I am not sure if I understand your question 100% but when you reindex with
the maintenance plan it issues a DBCC DBREINDEX. That command updates the
statistics automatically for you.
Andrew J. Kelly SQL MVP
"Przemo" <Przemo@.discussions.microsoft.com> wrote in message
news:7164A315-4775-4D80-BE09-0C06EE5112E5@.microsoft.com...
> Hi,
> Please tell me why isn't it possible to switch in one maintenance plan
> Reorganize data and index pages and Update the statistics used by the
> query
> optimizer?
> May be reorganizing data and indexes also updates statistics? but if yes,
> updates it all statistics or only some of them?
> Thanks
Please tell me why isn't it possible to switch in one maintenance plan
Reorganize data and index pages and Update the statistics used by the query
optimizer?
May be reorganizing data and indexes also updates statistics? but if yes,
updates it all statistics or only some of them?
Thanks
I am not sure if I understand your question 100% but when you reindex with
the maintenance plan it issues a DBCC DBREINDEX. That command updates the
statistics automatically for you.
Andrew J. Kelly SQL MVP
"Przemo" <Przemo@.discussions.microsoft.com> wrote in message
news:7164A315-4775-4D80-BE09-0C06EE5112E5@.microsoft.com...
> Hi,
> Please tell me why isn't it possible to switch in one maintenance plan
> Reorganize data and index pages and Update the statistics used by the
> query
> optimizer?
> May be reorganizing data and indexes also updates statistics? but if yes,
> updates it all statistics or only some of them?
> Thanks
Database Maintenance Plan
Hi,
Please tell me why isn't it possible to switch in one maintenance plan
Reorganize data and index pages and Update the statistics used by the query
optimizer?
May be reorganizing data and indexes also updates statistics? but if yes,
updates it all statistics or only some of them?
ThanksI am not sure if I understand your question 100% but when you reindex with
the maintenance plan it issues a DBCC DBREINDEX. That command updates the
statistics automatically for you.
--
Andrew J. Kelly SQL MVP
"Przemo" <Przemo@.discussions.microsoft.com> wrote in message
news:7164A315-4775-4D80-BE09-0C06EE5112E5@.microsoft.com...
> Hi,
> Please tell me why isn't it possible to switch in one maintenance plan
> Reorganize data and index pages and Update the statistics used by the
> query
> optimizer?
> May be reorganizing data and indexes also updates statistics? but if yes,
> updates it all statistics or only some of them?
> Thanks
Please tell me why isn't it possible to switch in one maintenance plan
Reorganize data and index pages and Update the statistics used by the query
optimizer?
May be reorganizing data and indexes also updates statistics? but if yes,
updates it all statistics or only some of them?
ThanksI am not sure if I understand your question 100% but when you reindex with
the maintenance plan it issues a DBCC DBREINDEX. That command updates the
statistics automatically for you.
--
Andrew J. Kelly SQL MVP
"Przemo" <Przemo@.discussions.microsoft.com> wrote in message
news:7164A315-4775-4D80-BE09-0C06EE5112E5@.microsoft.com...
> Hi,
> Please tell me why isn't it possible to switch in one maintenance plan
> Reorganize data and index pages and Update the statistics used by the
> query
> optimizer?
> May be reorganizing data and indexes also updates statistics? but if yes,
> updates it all statistics or only some of them?
> Thanks
Wednesday, March 7, 2012
Database Maintenance Plan
Hi,
Please tell me why isn't it possible to switch in one maintenance plan
Reorganize data and index pages and Update the statistics used by the query
optimizer?
May be reorganizing data and indexes also updates statistics? but if yes,
updates it all statistics or only some of them?
ThanksI am not sure if I understand your question 100% but when you reindex with
the maintenance plan it issues a DBCC DBREINDEX. That command updates the
statistics automatically for you.
Andrew J. Kelly SQL MVP
"Przemo" <Przemo@.discussions.microsoft.com> wrote in message
news:7164A315-4775-4D80-BE09-0C06EE5112E5@.microsoft.com...
> Hi,
> Please tell me why isn't it possible to switch in one maintenance plan
> Reorganize data and index pages and Update the statistics used by the
> query
> optimizer?
> May be reorganizing data and indexes also updates statistics? but if yes,
> updates it all statistics or only some of them?
> Thanks
Please tell me why isn't it possible to switch in one maintenance plan
Reorganize data and index pages and Update the statistics used by the query
optimizer?
May be reorganizing data and indexes also updates statistics? but if yes,
updates it all statistics or only some of them?
ThanksI am not sure if I understand your question 100% but when you reindex with
the maintenance plan it issues a DBCC DBREINDEX. That command updates the
statistics automatically for you.
Andrew J. Kelly SQL MVP
"Przemo" <Przemo@.discussions.microsoft.com> wrote in message
news:7164A315-4775-4D80-BE09-0C06EE5112E5@.microsoft.com...
> Hi,
> Please tell me why isn't it possible to switch in one maintenance plan
> Reorganize data and index pages and Update the statistics used by the
> query
> optimizer?
> May be reorganizing data and indexes also updates statistics? but if yes,
> updates it all statistics or only some of them?
> Thanks
Database Maintenace Plan
None of my jobs run the "Update statistics used by the
query optimizer" task, but I do run the "Reorganize data
and index pages". If this is selected I can't run Update
statistics used by the query optimizer. "Do I need a
specific job to update index stats? Is it necessary to
run both jobs?No, DBCC DBREINDEX includes a full update statistics.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:23fb501c45f78$02af65a0$a601280a@.phx.gbl...
> None of my jobs run the "Update statistics used by the
> query optimizer" task, but I do run the "Reorganize data
> and index pages". If this is selected I can't run Update
> statistics used by the query optimizer. "Do I need a
> specific job to update index stats? Is it necessary to
> run both jobs?|||If you run the DBCC very infrequently. You may wish to run another
maintenance plan that updates statistics..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:23fb501c45f78$02af65a0$a601280a@.phx.gbl...
> None of my jobs run the "Update statistics used by the
> query optimizer" task, but I do run the "Reorganize data
> and index pages". If this is selected I can't run Update
> statistics used by the query optimizer. "Do I need a
> specific job to update index stats? Is it necessary to
> run both jobs?
query optimizer" task, but I do run the "Reorganize data
and index pages". If this is selected I can't run Update
statistics used by the query optimizer. "Do I need a
specific job to update index stats? Is it necessary to
run both jobs?No, DBCC DBREINDEX includes a full update statistics.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:23fb501c45f78$02af65a0$a601280a@.phx.gbl...
> None of my jobs run the "Update statistics used by the
> query optimizer" task, but I do run the "Reorganize data
> and index pages". If this is selected I can't run Update
> statistics used by the query optimizer. "Do I need a
> specific job to update index stats? Is it necessary to
> run both jobs?|||If you run the DBCC very infrequently. You may wish to run another
maintenance plan that updates statistics..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:23fb501c45f78$02af65a0$a601280a@.phx.gbl...
> None of my jobs run the "Update statistics used by the
> query optimizer" task, but I do run the "Reorganize data
> and index pages". If this is selected I can't run Update
> statistics used by the query optimizer. "Do I need a
> specific job to update index stats? Is it necessary to
> run both jobs?
Database Maintenace Plan
None of my jobs run the "Update statistics used by the
query optimizer" task, but I do run the "Reorganize data
and index pages". If this is selected I can't run Update
statistics used by the query optimizer. "Do I need a
specific job to update index stats? Is it necessary to
run both jobs?
No, DBCC DBREINDEX includes a full update statistics.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:23fb501c45f78$02af65a0$a601280a@.phx.gbl...
> None of my jobs run the "Update statistics used by the
> query optimizer" task, but I do run the "Reorganize data
> and index pages". If this is selected I can't run Update
> statistics used by the query optimizer. "Do I need a
> specific job to update index stats? Is it necessary to
> run both jobs?
|||If you run the DBCC very infrequently. You may wish to run another
maintenance plan that updates statistics..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:23fb501c45f78$02af65a0$a601280a@.phx.gbl...
> None of my jobs run the "Update statistics used by the
> query optimizer" task, but I do run the "Reorganize data
> and index pages". If this is selected I can't run Update
> statistics used by the query optimizer. "Do I need a
> specific job to update index stats? Is it necessary to
> run both jobs?
query optimizer" task, but I do run the "Reorganize data
and index pages". If this is selected I can't run Update
statistics used by the query optimizer. "Do I need a
specific job to update index stats? Is it necessary to
run both jobs?
No, DBCC DBREINDEX includes a full update statistics.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:23fb501c45f78$02af65a0$a601280a@.phx.gbl...
> None of my jobs run the "Update statistics used by the
> query optimizer" task, but I do run the "Reorganize data
> and index pages". If this is selected I can't run Update
> statistics used by the query optimizer. "Do I need a
> specific job to update index stats? Is it necessary to
> run both jobs?
|||If you run the DBCC very infrequently. You may wish to run another
maintenance plan that updates statistics..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:23fb501c45f78$02af65a0$a601280a@.phx.gbl...
> None of my jobs run the "Update statistics used by the
> query optimizer" task, but I do run the "Reorganize data
> and index pages". If this is selected I can't run Update
> statistics used by the query optimizer. "Do I need a
> specific job to update index stats? Is it necessary to
> run both jobs?
Database Maintenace Plan
None of my jobs run the "Update statistics used by the
query optimizer" task, but I do run the "Reorganize data
and index pages". If this is selected I can't run Update
statistics used by the query optimizer. "Do I need a
specific job to update index stats? Is it necessary to
run both jobs?No, DBCC DBREINDEX includes a full update statistics.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:23fb501c45f78$02af65a0$a601280a@.phx
.gbl...
> None of my jobs run the "Update statistics used by the
> query optimizer" task, but I do run the "Reorganize data
> and index pages". If this is selected I can't run Update
> statistics used by the query optimizer. "Do I need a
> specific job to update index stats? Is it necessary to
> run both jobs?|||If you run the DBCC very infrequently. You may wish to run another
maintenance plan that updates statistics..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:23fb501c45f78$02af65a0$a601280a@.phx
.gbl...
> None of my jobs run the "Update statistics used by the
> query optimizer" task, but I do run the "Reorganize data
> and index pages". If this is selected I can't run Update
> statistics used by the query optimizer. "Do I need a
> specific job to update index stats? Is it necessary to
> run both jobs?
query optimizer" task, but I do run the "Reorganize data
and index pages". If this is selected I can't run Update
statistics used by the query optimizer. "Do I need a
specific job to update index stats? Is it necessary to
run both jobs?No, DBCC DBREINDEX includes a full update statistics.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:23fb501c45f78$02af65a0$a601280a@.phx
.gbl...
> None of my jobs run the "Update statistics used by the
> query optimizer" task, but I do run the "Reorganize data
> and index pages". If this is selected I can't run Update
> statistics used by the query optimizer. "Do I need a
> specific job to update index stats? Is it necessary to
> run both jobs?|||If you run the DBCC very infrequently. You may wish to run another
maintenance plan that updates statistics..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:23fb501c45f78$02af65a0$a601280a@.phx
.gbl...
> None of my jobs run the "Update statistics used by the
> query optimizer" task, but I do run the "Reorganize data
> and index pages". If this is selected I can't run Update
> statistics used by the query optimizer. "Do I need a
> specific job to update index stats? Is it necessary to
> run both jobs?
Subscribe to:
Posts (Atom)