• Truncate will be the fastest option since it will de-allocate all data pages from the table. How long will it take? It depends on the number of pages and your system performance. Do you have a test system you can use to get a timing?



    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]