RE: Removing rows from very large table with indices
From: Umut Nazlica (anonymous_at_discussions.microsoft.com)
Date: 03/12/04
- Next message: Amin Sobati: "Cannot create index on view"
- Previous message: Tibor Karaszi: "Re: Reporting Services DISABLES DEFAULT Transaction Isolation Level!!!"
- In reply to: javatopia: "RE: Removing rows from very large table with indices"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 12 Mar 2004 07:31:07 -0800
Hi,
Yes you can put db into single user mode using alter database and termination options like:
ALTER DATABASE XXX
SET SINGLE_USER WITH ROLLBACK AFTER X (See Books Online ..)
and you can schedule a job to automate it.
My suggestion is first script your table then create your new table using this script (at this point do not create the indexes on new table), transfer data, create indexes on new table and so on.
But test first to see if it works the way you want..
Regards..
- Next message: Amin Sobati: "Cannot create index on view"
- Previous message: Tibor Karaszi: "Re: Reporting Services DISABLES DEFAULT Transaction Isolation Level!!!"
- In reply to: javatopia: "RE: Removing rows from very large table with indices"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
