Best way to do mass delete of records MSsql server 2005 coldfusion
I want to migrate a database but reduce it first it is 10.5GB I have a lot of old statistics records that will reduce this right down. The database is online with customers, CF9. I ran a query from a template but it seems to bring down cold fusion. I have millions of rows to delete. What is the best way? Thanks. I am not a system engineer - more of a novice in this area.