Got to be something. I'm just glad the individual lives outside the US, half way around the world,...

I agree, how you delete a large number of records is also dependent on how many records are being deleted. In the article I was deleting approximately 10% of...

Not that simple. He isn't asking for help, he's...

-- I feel like I have a groupie! Has anyone else ever had someone that just would PM you about various SQL stuff? I gotta tell you...

timothyawiseman (9/15/2009)

---

Lynn Pettis (9/15/2009)

---

I have to make two observations about this article. As of just checking the main page, there have been 7,992 views recorded for this article. ...

My vision is an aggregate from several other threads today. Seems "It Depends" has been thrown around quite a bit both here on SSC as well as in...

I can see it now. All the heavy hitters and denizens of The Thread finally get together over a Christmas Holiday (with apologies to those who don't celebrate Christmas)....

Bob Hovious (9/15/2009)

---

I can't argue with "It depends."

Lynn, I need a judgment call from an official:

Is the above a more polite way...

Just don't mess up my scores. Mine finally match all across like they should! :w00t:

kjs714 (9/15/2009)

---

In the sample, you are using a batchsize of 10,000. This will end up causing a table lock unless the escalation gets blocked by other processes. If table locks...

rob.lobbe (9/15/2009)

---

This works if you are the ONLY one using the database.

Running in a production system you can't just go about changing the recovery model.

as for a 'batch' delete

select 1

while...

Sorry...

RBarryYoung (9/15/2009)

---

Silverfox (9/15/2009)

---

It has been 4 days since i posted about the points not being sync'd, my points are not even going up when i post in forums, nearly 500...

kailas.tare (9/15/2009)

---

Use table partitions feature of sql 2005 to arrange your table and then you just simply drop a partition, which creates very minimal logging and way better in performance...

I have to make two observations about this article. As of just checking the main page, there have been 7,992 views recorded for this article. Compare this to...