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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-09 : 08:26:08
|
| pnuyen writes "Hello all,I just go over this DBCC DBREINDEX Stored Procedure- http://weblogs.sqlteam.com/tarad/ by Tara and wonder if I need to kill all users in the database before running doing any re-indexing to the DB. What would the result(if any) if a user still connectioning to the DB while re-indexing occur?thanks" |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-01-10 : 01:20:34
|
| If I remember correctly, you do not need to kill all users while doing reindexing, the only catch is when you rebuilding the clustered index, the table will be locked out for any access at all. But for non-clustered, only performance impact for the current users. |
 |
|
|
|
|
|
re-index