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 |
|
Kuldip
Starting Member
4 Posts |
 Posted - 2014-06-13 : 02:19:15
|
| Can we run rebuld index on table while users are working with the database on sql server 2008r2? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-06-13 : 08:37:57
|
| I assume you are asking about accessibility of the table on which you are rebuilding the index. Yes, you can do an online rebuild but the feature is available only in Enterprise edition (and developer or evaluation version). There are some other restrictions as well, e.g., you cannot do online rebuild on an XML index.You can reorganize the index online. http://msdn.microsoft.com/en-us/library/ms189858(v=sql.105).aspx |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-06-16 : 01:44:08
|
| If possible, avoid peak hr index rebuilds as to minimise impact. Are you trying to make this index rebuild due to a recent data change or is it a performance issue?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Rebuld Indexes