Interesting editorial, Phil.

I tend to write procedures in the following way.

1. Identify from the requirements what the inputs and outputs should be.

2. Break the task into logical steps. Not procedural...

This raises a couple of points.

First, ditto what everyone else said about the @table variables. For me, the most important thing about them, and the thing that is most often...

Matt Miller (1/31/2008)

---

Sir Slicendice (1/31/2008)

---

No amount of testing and adding hints can ever make up for using functionality that is explicitly unsupported. What happened to defensive programming? Are...

Very interesting article.

I want to add my voice to those urging caution with regard to relying on order being forced by a clustered index. According to the SQL standard,...

I didn't agree with that part of the article, but I think that it is the way that the article is worded. It says:

"If the search will use a datetime...

We were having exactly the same problem. It had us scratching our heads for a couple of days, but the MAXDOP hint solves it, and we'll be patching to .818...