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 |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2013-05-25 : 08:29:59
|
| We have a OLAP based Databases running over the years as it built on one clustered and several non-clustered indexes.Is there anyway I can rebuilt Non-C;lustered?Please advise. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-25 : 09:38:14
|
| you mean rebuilt all in one go?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2013-06-20 : 00:53:58
|
| Sorry for the late communication. As identified with the most of the non-clustered indexes which have to be rebuilt either in one go or one by one based on the system strength.Any idea this is ok? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-20 : 01:33:48
|
| use ALTER TABLE...REBUILD ALLhttp://msdn.microsoft.com/en-us/library/ms188388(v=sql.105).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2013-06-20 : 21:40:51
|
| Thanks its now done. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-21 : 02:28:36
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Non Clustered