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 |
|
espanolanthony
Starting Member
9 Posts |
 Posted - 2009-11-11 : 14:11:33
|
| Hello friends, I am looking for a script that will rebuild/reorganise SQL Server's indexes if they have fragmentation above certain percentage and the main thing is that a script that rebuild/reorganise indexes online. since our database is very big in size its impossible to rebuild/reorganise after hours because if we run after hours it will take more than 24 hours to run. so i am looking for rebuild/reorganise script with online option. and one more thing i am looking for is, i heard that the online rebuild/reorganise operation will not rebuild/reorganise certain indexes which cannot be rebiult online. so does someone also have script that will find those indexes that will not be rebuilt with onlin option. Any help in this matter is appreciated. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
espanolanthony
Starting Member
9 Posts |
Posted - 2009-11-11 : 14:43:55
|
| so is this an online operation? |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-11-11 : 19:23:01
|
quote:
Originally posted by espanolanthony
so is this an online operation?
Did you even read that blog entry?CODO ERGO SUM |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
reindex/rebuilt online script needed.....