Jeff Moden (10/21/2012)

---

While I agree that some developers are better than others and some deserve to be shot out of a cannon into a stone wall, I think way too...

Stefan Krzywicki (10/22/2012)

---

Brandie Tarvin (10/22/2012)

---

[font="Comic Sans MS"]The PI! It needs more slices![/font]

You know what I hate about pie charts?

You can never tell what filling they're using. And it's awfully...

Nice easy question.

sqlfriends (10/20/2012)

---

I see on dev server, it starts from 5000001, but on prod, it starts from 5000000.

The only diffrence is on dev, I run 1 and 2 in one batch...

CELKO (10/20/2012)

---

Rows are not records. one of the many they differ is that rows must have a key. A key is a subset of attributes which uniquely identifies the row....

Don't try to write anything over-complicated. The KISS principal applies here.

Keep the join condition separate from any other filters, which should be written as where conditions.

Try to use only...

Well, I'm totally in favour of Ms Smith's views, except perhaps where she writes "Explicitly dealing with failure" in her list of problems where she clearly means "Not explicitly dealing...

GilaMonster (10/21/2012)

---

L' Eomot Inversé (10/21/2012)

---

The reason this was useful instead of a catastrophic mistake was that you were selecting only 1 row

in about 100,000 rather than 1 row in...

Lee Crain (10/20/2012)

---

But let's look at the worst case. Let's say that:

> the data in the column is evenly distributed. There are exactly 12,500,000 rows for each of the 4...

Lee Crain (10/20/2012)

---

Gail,

If the original poster creates an index on just the column with the 4 values, will this not force the Optimizer to use that index?

"SELECT <column names> FROM...

There's a third option: add included columns to this index, so that it becomes a covering index for the critical query. Then the optimiser sees that there are no...

patrickmcginnis59 (10/19/2012)

---

True!...

Hugo Kornelis (10/19/2012)

---

L' Eomot Inversé (10/19/2012)

---

Actually, there's a misprint in the question (my stupid error) - it should say @ROWGUIDCOL, not ROWGUID. You can have as many rowguid columns...

patrickmcginnis59 (10/19/2012)

---

L' Eomot Inversé (10/19/2012)

---

Maybe some programmers, but other programmers consider the statement

that SQL Server doesn't correctly manage the size of tempdb to be either incorrect or at...

arthur.teter (10/19/2012)

---

While I know you are not supposed to be able to add multiple GUIDs to any table, on the systems I have worked on I have found that with...