Welcome to WebmasterWorld Guest from 54.144.107.83

Forum Moderators: open

Message Too Old, No Replies

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)

Junior Member

5+ Year Member

joined:Sept 16, 2007
posts:42
votes: 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.