Hugo Kornelis (12/6/2011)

---

(For some reason I can't really explain, I am not very fond of the derived table version - I've used derived tables when needed, but always found the...

Hugo Kornelis (12/6/2011)

---

The few timies where I did choose to use nested joins in actual code, I have always used parentheses and indentation for easier reading. In fact, my first...

michael.kaufmann (12/6/2011)

---

One minor flaw I'd attribute to speedily writing this query--the above one will only yield the same result as the original one if only employees are the customers and...

Even in SQL Server 2000, you...

den_sidr (12/6/2011)

---

Also i know that in ORACLE it is possible to observe such activity, using Toad tool for example, you can see the index scan or index seek or sort...

Hi Hugo,

Writing a question to demonstrate the equivalence of SQL expressions is very brave, so well done for that. Small point: in the explanation you say, "the only way...

Thanks, Tom.

L' Eomot Inversé (11/22/2011)

---

Nice question, but only works for non-empty tables.

The reason it doesn't work for empty tables is an excellent illustration of SQL's idiotic confustion between emptiness and...

GilaMonster (11/17/2011)

---

Ola L Martins-329921 (11/17/2011)

---

The "AND" operator will check against the date-columns seperately - not simultaneously which in the case with "BETWEEN".

Using GREATER THAN and LESS THAN in the above...

Done (because I like the clown avatar).

jswong05 (11/15/2011)

---

To me the answer should not depend on data type.

C - case

I - Insensitive

A - Accent

S - Sesitive

b and B cannot be Accent differentiated

b and...

You're welcome. It is a horribly confusing area. If I had more direct experience with this...

SQLSeTTeR (11/15/2011)

---

After reading what you recommended, should I be seeing 64 cpu's on the SQL 2008 boxes? Why am I seeing 20 cpu's on one and 40 cpu's on...

Brandie Tarvin (11/15/2011)

---

Does this mean SQL 2008 (regular) will never show more than...

I like this question too. Table variables often get a poor press, but not allowing named constraints (which could well conflict for objects in tempdb) is one thing I...