Lynn Pettis (9/11/2012)

---

ChrisM@Work (9/11/2012)

---

Lynn Pettis (9/11/2012)

---

ChrisM@Work (9/11/2012)

---

oscarooko (9/11/2012)

---

It actually took me 47 minute to delete 13 684 records in batches of 100. I am there's got to be a faster...

Oops..My apologies...Didn't mean to put that up there too many post that so many time!...

How do I make it a smaller transaction?

I am using SQL Server 2008R2

I am using 2008R2

It actually took me 47 minute to delete 13 684 records in batches of 100. I am there's got to be a faster way, and one of you good folks...

Lynn Pettis (9/11/2012)

---

ChrisM@Work (9/11/2012)

---

Lynn Pettis (9/11/2012)

---

ChrisM@Work (9/11/2012)

---

oscarooko (9/11/2012)

---

I am trying to delete old records from a table, and insert them into another table. Problem is that it is taking...

This is the query I have. I already considered deleting in batches

CREATE PROCEDURE [dbo].[usp_SPT_ArchiveLog]

(@dCutOffDate DateTime)

AS

BEGIN

SET NOCOUNT ON;

BEGIN TRY

BEGIN TRAN

INSERT INTO [dbo].[SPTLogArchive]

...