I agree strongly with peter-757102 and raulggonzalez.

However the point of a date dimension is not that is stores all of the days of a year. That's trivial. The...

Sean Lange (11/6/2013)

---

By far the simplest approach here is to use the technique I described. I guess since everyone is completely ignoring it that either I have lost my mind...

Luis Cazares (11/6/2013)

---

steven.ensslen (11/6/2013)

---

If I had to guess, the problem is that a single DELETE is too large to fit in the transaction log. DELETE is the wrong tool...

If I had to guess, the problem is that a single DELETE is too large to fit in the transaction log. DELETE is the wrong tool for the job....