Posted by Massimo-Mastino on 02/28/07 23:11

I will evaluate this way too, but we have to work with millions records
tables.
Thanx



"Erland Sommarskog" <esquel@sommarskog.se> ha scritto nel messaggio
news:Xns98E5ED0FE4612Yazorman@127.0.0.1...
> 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: SQL Server Upgrade Wizard
• Prev in forum: Re: Reading a directory
• Thread view: Re: millions records archiving and delete

[Reply to this message]