homepage Welcome to WebmasterWorld Guest from 54.234.2.88
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
How-To PAUSe SQL Server 2005 reindex
I want to pause sql server recalculate index a period of time
Eric




msg:3601026
 9:13 pm on Mar 14, 2008 (gmt 0)

Hi there

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.

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved