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 |
|
obscurr
Starting Member
2 Posts |
 Posted - 2008-05-08 : 03:42:41
|
| Hi, I'm configuring a maintenance plan for my SQL Server 2005. Is the order of things important here? I can't seem to find any best practices for this anywhere.Obscurr |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-08 : 11:14:51
|
| What is issue? Order depends on how you want. Show us what you have tried so far and what is your requirement? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-08 : 23:05:50
|
| Task order listed in wizard works in most cases. |
|
|
|
obscurr
Starting Member
2 Posts |
Posted - 2008-05-09 : 06:34:14
|
| Is it for instance important to rebuild index before update statistics? Should shrinking the database be the first thing to do in a maintenance plan? Or is the order of when to do what totally irrelevant?obscurr |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-09 : 12:08:43
|
| 1) Rebuilding index will automatically update stats but not in case with reorganizing index.2)Don't shrink you database.It will shuffle your datapages and index pages big time. |
|
|
|
|
|
|
Maintenance plan - order important?