You are welcome. Your first post was a good one, so I thought you deserved more than a one-line reply. 🙂

Rahul,

The explanation will be an easy one - we just need you to save an actual execution plan (right-click, Save Execution Plan As...) then zip it up and attach it...

The first eight pages of a table are allocated from mixed extents. These pages will therefore almost certainly always be technically logically fragmented. If the table is relatively...

Yes. The delay caused by returning the output to the client and displaying them will vastly dominate the cost of merge joining 10K rows. Many performance tests of...

anish_ns (8/6/2009)

---

Was something definitely to do with the filtering. I just ran a trace for over 10 minutes without any filters in place. Even though the system was busy, the...

Jeff Moden (8/6/2009)

---

Ah... got it. My only confusion now would be the same as on the MSDN thread because the note in BOL simply states "The MSXML parser uses...

Pretty fair comments by Jeff I thought. I wonder if it is the same guy? He certainly seems spookily similar in posting style...?

My favourite part of his posted...

Very cool! Rated five stars - I particularly like the effort made with the article 's presentation, the structure of the SQL (CTEs and nested FOR XML are a...

Welcome to the users-frustrated-with-the-site-code-windows club! 🙂

Here's an interesting variation:

This script is the same as the last, except it also includes a test run with a denormalized version.

Sample results included in the script comments as before.

(The...

Jeff Moden (8/5/2009)

---

As a side bar... There is a rumor (and I STRESS the word RUMOR!) I heard and I can't confirm it or deny it. The rumor says...

Briefly, I meant that...

So don't get me wrong: XML support is a useful addition to the SQL Server toolkit - even in OLTP applications. As usual it's a case of using...

Not going to quote them all but you guys are funny today!!!

Awesome work.

🙂

Hey Steve!

CTRL+C, CTRL+V, F5 :laugh:

(The test...