hrvoje.piasevoli (7/23/2010)

---

I guess now would be a good time to point to a great post by PaulWhiteNz about UDFs and SCHEMABINDING which I can not find right now. My read...

Lucky guess - didn't know for sure. Good question!

tasnim.siddiqi (7/22/2010)

---

The sub-query is the bit between the braces, the sub-query in itself is fine and valid, its because we are using an operator that expects comparison against a constant...

Can you work out why that line in your procedure gives an error now? 😉

You have my up-vote 🙂

Ooo I do like a good game of Risk. Not...

How many check boxes are too many? :w00t:

"The engine tweaks to be performant."

I ticked that.

Paul

This is becoming the discussion from your original QotD again.

I'm sure I checked at the time and 2008...

GilaMonster (7/22/2010)

---

Depends how deep into the engine you want to go. So deep that they all look the same and talking about types of indexes becomes pointless. There's one -...

It used to be quite easy - though you had...

GilaMonster (7/22/2010)

---

Yes it is, because it can only be defined on an XML column, because it doesn't...

GilaMonster (7/22/2010)

---

In sys.indexes yes, because there has to be an entry for a table without a clustered index. I wouldn't call it an index though (more like the absence of...

Steve,

Even 'structure' of an index gets controversial (remember Wayne's QotD?)

It's all a bit loose and fluffy, and open to personal interpretation.

A primary XML index is clearly different from a clustered...

Heap? As an index type? My brain hurts.

Thanks for the tidy-up BT. Sorry I didn't respond sooner - time zone issues 🙂

edit: though to get strictly the same execution plan, I'd need to modify the final...