Golfer22 (6/2/2013)

---

Lets say I have a table with four columns named PersonID1, PersonID2, JobTitle, and PreviousJobTitle. There is a composite primary key on PersonID1 and PersonID2. In all...

I vastly prefer this to the previous QOTD. It's straightforward, nice clear and accurate explanation, and doesn't make my brain hurt.

I did get it, in the sense that I think I .understood the tortuous misuse of the English language in the formulation of the question....

Jack Corbett (5/31/2013)

---

Have I mentioned these 2 things lately:

1. I can't stand ORM tools and the queries they create

2. I can't stand when developers create databases...

The Dixie Flatline (5/30/2013)

---

GilaMonster (5/30/2013)

---

I just delete that kind of thing outright, long with the 'Answer my posted question', 'explain life, the universe and everything to me' and other such...

That's a fun question.

But maybe there will be complaints from some who think QotD should test only knowledge and not reasoning (except perhaps very trivial reasoning).

Hugo Kornelis (5/29/2013)[hrHowever, I would definitely also explore the option of using a checksum instead of a substring as the first quick test. And if I were a gambler, I...

Hugo Kornelis (5/28/2013)

---

L' Eomot Inversé (5/28/2013)

---

There is indeed a rule that no column with type nvarchar(max), varchar(max) or varbinary(max) can be used in index keys. However, it isn't documented...

Nice question.

Dineshbabu (5/29/2013)

---

I don't have idea about filestream but i'm sure other than IDENTITY property no other attributes will be copied to new table. So i guessed it should be...

Definitely an interesting one.

The question is fine and the "correct" answer is correct, but the reference is not helpful because it explicitly states that an index where the maximum...

S Hodkinson (5/28/2013)

---

Well it may have been quiet for some but not me! Leaving aside various family stuff, my previous employers have called me back in about 4 times...

Lucy08 (5/27/2013)

---

Hi,

I need to fetch rows from a table in SP depending on input parameter value.

@var is an input parameter which i am passing

if @var = no owner assigned'...

zerko (5/27/2013)

---

But surely, since ALL of us ALWAYS screen-lock our computers when we are not physically present, and the error message required someone else to type it into the SSMS...

Yes, very...

There's a nice missing note in this warning from Steve in the Employer / Employee section - it surprises me that it has survived over six years without correction:

---

This forum...