Posted by Erland Sommarskog on 02/28/07 22:20

Mastino (mastino@hotmail.it) writes:
> I do not want, and I cannot use partitioned wiews, I have to delete what
> we do not need any more.

Why would partitioned views prevent that? When it's time to delete old data,
you first redefine the view, so that the tables to be dropped are not
in the view any more. Then deleting is just dropping the table.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: SQL Help with purging old data
• Prev in forum: Re: SQL Help
• Thread view: Re: millions records archiving and delete

[Reply to this message]