Ok so Barry and Bruce made me laugh out loud in the office again. (Wayne's discussion).

Gah! 😀

It would be a useful addition, yes. Of course OPTION (RECOMPILE) is not a panacea - recompiling for every execution...

Tim Walker (6/10/2009)

---

...what is the point in defining a unique constraint on a table variable? Won't the 'optimized assuming one row in a table variable' render this unnecessary because the...

usman.tanveer (6/11/2009)

---

Windows server 2003 Enterprise sp2, and .net 2.0

btw my colleague is able to deploy the same code, we both have the sysadmin rights on sql server, but i am...

My guess is that it is the index(es) on the destination table that cause the problem.

Try dropping the indexes and then doing the insert.

Create appropriate and valid index(es) afterward.

No worries, I enjoyed answering the question.

Now there's a phrase you won't hear every day. 😀

GilaMonster (6/7/2009)

---

Yeah, I noticed the similarity between your post and the book when I checked it myself. It's not the one I was referring to and it's not the one...

GilaMonster (6/7/2009)

---

Nope. Algebriser doesn't even appear in the index of that one. There's a good discussion of the optimiser, but the only mention of the algebriser that I found is...

In principle, you could get the page number from the page lock associated with the RID/KEY lock you are interested in, and then use the undocumented DBCC PAGE ('DatabaseName', file_id,...

GilaMonster (6/7/2009)

---

That algebriser also does certain forms of expression conversion including flattening some expressions, does type derivation and binds aggregates and groupings. There's a good section in one of the...

Hey David, I'm sure your answer was better for anyone who...

For anyone wondering about the 'algebrizer':

The compilation process (which also includes optimization) goes through the three stages Gail described.

1. The parser validates the syntax of the statement and then...

Yes. SQL Server works differently from some other programming languages you...