Chris Howarth-536003 (5/6/2010)

---

I was surprised to see that this is also the case for a database using the 'Full' recovery model (and where a full backup has previously been taken)....

It is useful to know a bit about how the transaction log works. See the following Books Online links:

Transaction Log Architecture

Managing the Size of the Transaction Log File

Top 6...

Ooo! I came over all creative and posted a solution! :w00t:

Time for...

I've had a much better idea. Create an XML format file like so:

<?xml version="1.0" ?>

<BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<RECORD>

<FIELD ID="01" xsi:type="CharTerm" TERMINATOR="|" MAX_LENGTH="50"/>

...

Jeff Moden (5/5/2010)

---

I was also very surprised by the CLR for this. As you said, it had to get to almost 2 million rows which I didn't really believe...

johnzabroski (5/5/2010)

---

I am sure there are millions of better ways to do this, and I don't care. I just want to know how I can debug this and see...

Yes, that must...

Tim,

Yes the MIN/MAX rewrite rule is still broken in 2008 that is true - don't know anyone with R2 to test it there though.

The parallelism thing really made partitioning just...

Nice. Glad you posted a link 🙂

Lynn Pettis (5/5/2010)

---

First, not currently...

Edited my post to reflect your opinion 🙂

So, I was thinking of the...

Jeff Moden (5/4/2010)

---

I'd really be interested in seeing what a CLR could do with this one way or the other because it would be another "data point" for the ol'...

Sounds all too familiar. Work sucks - and almost everywhere is the same, eventually.

Have I cheered you up at all? 😀

Oh I agree - but to be fair...

Solomon Rutzky (5/5/2010)

---

Hey Paul. Actually, I had not had time to test the CROSS APPLY approach and was answering in terms of my solution against the simple WHERE clause...