A bit unfortunate about the read only option. An interesting QotD might have been "True or False: The model database can be set to READ_ONLY" ... that would have...

Actually, pretty much every other post so far has covered it :w00t: and Rune responded:

"Yep, I was wrong about...

Hugo Kornelis (4/16/2010)

---

Second, Field 1 is not actually the object id of the column, but rather the column id. Columns are identified by a combination of object id (of the...

I would like to express my sincere thanks to the following people, for their help in producing this article:

Amanda Lawrence

Jeff Moden MVP

Chris Morris

Lutz Müller

Jason Brimhall[/url]

Paul

This is true by default, but a PK will be created as non-clustered if it is added to a table that already has a clustered index.

CREATE...

It's a mis-print; it should...

Classic.

Even shorter?

SELECT @Date+1+88*((@date%100)/12)

SELECT K,

ISNULL(NULLIF(CONVERT(BIT, SIGN(SUM(MONEY) - 999) - 1), 0) * SUM(MONEY), $999)

FROM AAA

GROUP BY K;

New for 2008, a filtered unique index can allow an unlimited number of NULLs.

One of my favourite threads ever on here.

Michael H Lutz (4/17/2010)

---

..There is one thing I see though that is incorrect, the statement " This means that the execution plan for table variables will always treat the table...

Until that one time when the backup turns out to be corrupt 😉

I...

Stefan_G (4/16/2010)

---

The problem is that the code you tested represents a very different problem than the original problem. Just testing the mapping might of course still be interesting we just...

Stefan_G (4/16/2010)

---

Could you possibly post the actual SQL used in your tests ?

You dont have to post a full repro script, but it would be interesting to see the actual...