Off The Subject... SQL Question

Sorry for this question that doesn't pertain to the CF Talk List. I have a NT4.0 Box w/SQL 6.5 Server with Dual PII 650's / 512MB Ram. 256MB set aside for SQL. I have a table in one of my Datasources that has apprx 5 million records. I'm trying to think of the best way to purge the records and

Off The Subject... SQL Question

Sorry for this question that doesn't pertain to the CF Talk List. I have a NT4.0 Box w/SQL 6.5 Server with Dual PII 650's / 512MB Ram. 256MB set aside for SQL. I have a table in one of my Datasources that has apprx 5 million records. I'm trying to think of the best way to purge the records and