Erm... I think i'm missing something. Isn't 100 the default fillfactor for any index where...

Jeff

You are intensely cool. 1.796. And I'll agree with what was said above - i am most impressed by the way you got the data out of that table. Ultimate...

RBarryYoung (1/3/2009)

---

You know, I'm not sure how much point there is to this particular exercise. 90% of the time is in the intiial scanning of the WebLogEvents table and...

Ok then - my entry, given the size of the dataset will be the code below.

I'm not sure if the UNION approach to getting the data out of the table...

Jeff Moden (1/3/2009)

---

Then, if no one has any objections, there are certain huge peformance benefits to NOT using a TVF in this case... I'm just gonna do it as a...

Ok - here's one for you then...

Before i start - a couple of things. Given the volume of data you're talking about, i'm not confident my first method would be...

Jeff Moden (1/2/2009)

---

My answer to all of that is that code portability is a myth (and a nutty one, at that). ...snip... If that's the case, then why...

Jeff Moden (1/2/2009)

---

jacroberts (1/2/2009)

---

TheSQLGuru (1/2/2009)

---

jacroberts, I am pretty sure (>90%) that your problem can be solved with a self-join set-based solution. If the table is properly indexed that solution...

TheSQLGuru (1/2/2009)

---

jacroberts, I am pretty sure (>90%) that your problem can be solved with a self-join set-based solution. If the table is properly indexed that solution could well be...

I did that the second time! 🙂 I didn't know Ctrl-A, Ctrl-C was a shortcut for 'work this time please'. 🙂

Hmmm. Just wrote a massive reply and the session timed out!!

Oh well. The long and short of it was:

1) It's pretty trendy to bash microsoft, but I'm going to have...

Daym.

Has anyone told him about using DELETE...

Fair enough. I re-read it today...

Jeff

You know what, I have to say - would it kill you to agree with what people have said rather than repeat what other people say and try to pass...

@jacroberts -

I didn't get any faster results out of the firehose than I did out of the select-only method. I ran it a few times, they came out pretty much...