lmu92 (2/6/2010)

---

CirquedeSQLeil (2/6/2010)

---

13 - to be used when target system is more than 1024 miles away (might be safe to turn it on starting at an estimated range of 800...

Best QOTD I've seen for a while. It forced me to think.

I see that the SP uses varchar(max) so the base must be at least SQLS2005, so probably you should not have considered using syscomments, which exists in 2005 and 2008...

I think that what is going on here is that the properties of the connection are over-riding the DB option - the connection supporting a QA or SMSS query window...

Trouble with this question is that it is oversimplified.

For passwords there's a need to distinguish between (i) the passwords of individual people, (ii) group passwords, (iii) functional passwords which are...

paul.goldstraw (2/15/2010)

---

No it isn't, not if you're not clicking a link from an email. The emails contain the author of the question but the question page itself does not, see...

kaspencer (1/28/2010)

---

However, if you look at an un answered question (next time), you will see that it is actually quite difficult (no doubt deliberately) to read a thread on a...

bitbucket-25253 (2/14/2010)

---

Isn't that just what I gave in the Explanation? At one time you say the explanation not saying enough and yet you state that MS description you agree...

sknox (2/1/2010)

---

To be strict, the source data was a red herring. A where clause shouldn't be based on the data you have, but the data you want.

In this case, for...

bitbucket-25253 (2/14/2010)

---

From the reference cited...

Yes, that's what I meant when I said MS must have forgotten to change...

mbarrington (1/25/2010)

---

While this doesn't invalidate any points made about archaic prefixing practices in people use in DBs, maybe you would be interested in this tidbit on Hungarian Notation...

http://www.joelonsoftware.com/articles/Wrong.html

If you skip...

GilaMonster (1/25/2010)

---

The only thing that I use prefixes on are indexes, primary keys and unique constraints. Why? Well, two reasons. They never appear in code (or at least shouldn't) and...

WayneS (1/24/2010)

---

The explanation, while by itself is accurate, in the context of this question does not really provide an adequate explanation.

A better explanation might be explaining how, with cascading deletes,...

I think it's probably impossible to manage something you know nothing about unless you have the sort of personality that can comfortably delegate real decision making power to others. ...