kwhytee (6/28/2011)

---

I tested both these queries out and found no difference in performance - however my colleague is still convinced that in certain circumstances the >= operator will perform worse...

mister.magoo (6/27/2011)

---

Why did I bother posting this?.... well, I like this construct for updates mostly as the visual seperation of the SELECT from the UPDATE or the DELETE makes it...

That's actually not a huge surprise: SQL Server 2008 is a very different product from...

The spatial CLR user-defined data types are LOBs/large objects? Really???

Duncan Pryde (3/20/2011)

---

Thanks - high praise indeed! I must mention though, that when...

One can delete 9 rows non-deterministically with this code:

DELETE TOP (9) @t

Though in practice you're likely to see the same 9 rows deleted, it's just not guaranteed. To go...

4% of people still chose 'All'. I wonder what their second choice...

Hesitated over this one. Compiled plans are re-entrant, but the execution contexts derived from them are not. By 'query plan' I guessed the author of the question was...

I chose Compiled Plans and Execution Contexts, based on the information in:

http://blogs.msdn.com/b/sqlprogrammability/archive/2007/01/09/1-0-structure-of-the-plan-cache-and-types-of-cached-objects.aspx

Phrase #5, I think...

+1 :smooooth:

+1. Absolutely enable HT on Nehalem architecture or later.

h.berg-884044 (1/24/2011)

---

And that's the mistake most people make when it comes to hyperthreading. The two threads on the logical cores don't run simultaneously,...

A DBA...

The last point I want to make is that FORCE ORDER is an immensely powerful hint with many counter-intuitive side-effects, so it should be used exceedingly sparingly, and only by...