Just to throw in my 2c, I try to stay away from techniques that do not work reasonably efficient or completely break down in other ways when the query to...

Good one Jeff.

I scanned the article quicly and it is well presented.

But I do have to dive into this particular one as I feel something odd is happening. The optimized statement is...

Excellent and with enough extra material to make it interesting for those already familiar with apply!

IT requires a certain intellect and personality types at the same time. Miss out on one of these and no way in hell are you going excel at it. Consequently...

Paul White NZ (4/9/2010)

---

Constraints are always schema-scoped objects - see sys.objects.

This is...

Strange, indeed column defaults and primary keys seem not be properly mapped transparently when applied to temp tables.

This can be seen as either a design flaw or an implementation bug...

Cliff Jones (4/9/2010)

---

peter-757102 (4/9/2010)

---

Cliff Jones (4/9/2010)

---

Also explicit naming of indexes and such on a temporary table will come around to bite you, glad you covered that. Very nice job...

I...

akl (3/31/2010)

---

The use or ORM for object/relation mapping should be called Object Data Mapping since the objects know nothing of relations to any other object. Data elements in objects are...

The first ORM I worked with was from the early 90s. It was a non public implementation, and I was unaware of any public ones at the time (the internet...

Man, am I happy to not work in theory, but in the material world (reallity, or at least my experience of it). We can dream up a lot of wonderful...

CraigIW (2/10/2010)

---

No, as the "top 1" is only done after the "select 1...

Outstanding article...clear in meaning, no clutter or distractions, straight to the point.

It is also enlightening to see some of the beginner mistakes I made so many years ago when I...

Look at the recursive part as just as another expression that is transplanted everywhere it is being used. Just as would be the case if the CTE would be located...