naas2005 (5/8/2014)

---

Just a note on the tinyint - to store negatives in one byte the rightmost bit of the byte (111111 0) would need to be used to sign it...

Howitzer

Apologies to eveyone for the two stupid errors, one in the question and one in the explanation.

The second answer option should have read "Enterprise and Standard editions". ...

Patriarch

latter

Nice question. I didn't know the answer, so had to look it up in BOL. I didn't use the reference provided in the explanation, because tehobvios place to...

Puss (in them)

Well, if he allows tinyint and smallint and int and bigint why...

In the jobs that I enjoyed doing, when I hit something new, if I found I was sure I could handle it I immediately handed it on to a junior;...

Jeff Moden (5/5/2014)

---

The only thing left to do is do it right because neither cheap or fast is possible without doing it right. And, as Tom Thompson said on...

As a number of people have said, the article applies the triangle to a process for which it was never intended. The triangle is about research and development processes,...

There aren't any duplicates here, and nothing that needs fixing.

There is one row for each partition. It contains an object_id which is teh object_id of the table of which...

Hugo Kornelis (5/6/2014)

---

Fun story, nice question - shame about the sloppy execution.

I found myself in that position where I have to second-guess the question author. I knew it was either...

Jeff Moden (5/5/2014)

---

Steve Jones - SSC Editor (5/5/2014)

---

Jeff Moden (5/3/2014)

---

I think a much better question would be, "What determines what will be the first (top) table (according to books online)...

Hugo Kornelis (5/5/2014)

---

TomThomson (5/4/2014)

---

If you use that code to try to create the trigger, the trigger will do nothing - the code is syntactically incorrect because the create trigger statement...