Craig Farrell (5/23/2011)

---

Attached find the two after the index is in play. Sorry for the confusion. This is common for the difference in times between the two after...

SQLRNNR (5/23/2011)

---

For fun, I added a third query to the mix to see how it would perform. It uses the same exact plan, outputs the same statistics IO as...

Hi Craig,

Looking at the first two query plans you posted (without your index), the optimizer does pick the better plan - where better = lowest estimated cost. The estimated...

Swung by 🙂

Hi Craig,

The following index appears optimal to me for this query:

CREATE UNIQUE NONCLUSTERED INDEX [UQ dbo.PriceHistoryTable_25000_NoBuf -ItemID, -UpdateDate (ItemPrice)]

ON PriceHistoryTable_25000_NoBuf (ItemID DESC, UpdateDate DESC)

INCLUDE (ItemPrice);

It allows the Segment...

Peter Trast (5/16/2011)

---

The explanation makes plenty of sense. I was just wondering what the threshold is. "Significant" is subjective. I was hoping for a percentage or formula or something like...

Good question today.

peter-757102 (5/14/2011)

---

While CLR certainly works on a technical level, it is far from a perfect merger with SQL Server. Ideal would be to have basic programming capabilities comparable to that...

Tom.Thomson (5/13/2011)

---

(1) New Zealanders (or at least one of then) don't use the position in the clause of "only" to distinguish the three possible meanings that the combination of "only"...

😀 😎

May implies it may or may not be true. It does...

cfradenburg (5/13/2011)

---

The text data type, which I assumed this is referring to, is LOB and will be stored on a LOB page regardless of length. If this were...

"Extents may be owned by only one object".

This still reads (to me) as excluding the possibility that an extent may be...

I very much doubt this was the intention of...

Hi Nils,

Just a...

The 'quibbling' over this QotD is quite understandable.

I chose the first two options and the last two, because the question said to choose four options. I was told that...