| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
|How-To PAUSe SQL Server 2005 reindex|
I want to pause sql server recalculate index a period of time
| 9:13 pm on Mar 14, 2008 (gmt 0)|
I use Sql server 2005, I know it will recalculate index as well as statistics when I update/delete/insert etc.
When it recalcuating, it need resources, mem and cpus etc. I have a period of time need massive update whole table, and I do not want it recalcuate while I am changing the table.
So I want to know, is there any sql can be used to pause the recalculate procedure, thanks.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved