Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2004-12-14 : 08:32:01
|
| If I check the "Reorganize Data and Index Pages" under Optimization tab in database maintenance plan, then would it re-index my database?Thanks,Canada DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-14 : 13:01:38
|
| Yes. But you see what the problem with maintenance plans is though? You don't know exactly what it is doing, so don't use them. Write your own. For reindexing, you just need DBCC DBREINDEX. If you want to see some examples of stored procedures that do database maintenance, then look here:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspxTara |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2004-12-14 : 16:30:10
|
| Just to amplify on what Tara has told you. It may sound a bit unusual to say don't use the maintenance plans but there have been a lot of reported issues with them.In addition to running DBCC DBREINDEX as described, you may want to run DBCC CHECKDB. See BOL for some details under the "DBCC CHECKDB Recommendations" heading.HTH=================================================================Happy Holidays! |
|
|
|
|
|
|
Does Optimizations reindex the DB?