Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
rebuilding indexes online
yeah I'm using a GO statement, but if I write ALTER INDEX A... GO ALTER INDEX B.. GO will the script wait with altering the index B untill index A has been changed? Because it can take a bit off time and if the rebuilding happens on another thread I might be spawning 15-20 thread clogging up...- baykey
- Post #3
- Forum: Microsoft SQL Server: Setup and Administration
-
rebuilding indexes online
I'm trying to write a script to run automatically and rebuild my indexes. But I'm kind of scared of running it. 'Cause I don't know what the server does with the command. What happens if I have a script that sends 20 "REBUILD WITH (ONLINE=ON);" commands to the server? Are these 20 commands...- baykey
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Setup and Administration
