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...

And for the reason one should test, test, and test again in your specific environment. What works best in one environment may not work in another.

timothyawiseman (9/15/2009)

---

Great article, Lynn.

One area that you mentioned, but that I think can be elaborated on, is the number of log backups this can generate. If the space is...

Jonathan (9/15/2009)

---

Does this mean you've found a method that's faster than...

Matt Whitfield (9/15/2009)

---

He did say there...

robblackin (9/15/2009)

---

I just had to deal with this. However, I need to have an hourly sliding window where I delete records older than 3 hours for working with .net viewstate.

I...