Maybe I'm committing an egregious social error by raising something technical in this forum, but sometimes I thing deprecation lists are at least as political as technical, besides which the...

Steve Jones - SSC Editor (8/2/2013)

---

We're in disagreement here. I think it is cleaner, and it's not squeezed into half the space. It's narrower, but it's spread out. That's less...

Nice to see a question on locking - it would be good if technical internals stuff like this turned up more often in QOTD.

The lesson to be taken from the...

Erland Sommarskog (8/1/2013)

---

L' Eomot Inversé (2013-07-31)

---

I think that might depend on your auditing policy. Several logins might have the same capabilities, so map to the same usernames (using usernames...

PHYData DBA (8/1/2013)

---

Also from MSDN article http://msdn.microsoft.com/en-us/library/ms190476(v=sql.110).aspx

Length for a numeric data type is the number of bytes that are used to store the number. Length for a character string or...

PHYData DBA (8/1/2013)

---

Hugo Kornelis (8/1/2013)SELECT LEN(@var) implicitly converts @var to string, because that's the only data type supported for LEN. This conversion is independent of the clients' Windows locale setting,...

Sounds crazy to me,...

laurie-789651 (7/31/2013)

---

I've never seen any convention on this. It's best to give a DB a short meaningful name with no spaces. Sometimes DB names may be for example...

Erland Sommarskog (7/31/2013)

---

Normally, the name of the database user and the server login are the same. Rarely, there is any reason to use different names. (The one exception is when...

GilaMonster (7/31/2013)

---

http://msdn.microsoft.com/en-us/library/ms187332.aspx

DBCC CHECKFILEGROUP (Transact-SQL)

Checks the allocation and structural integrity of all tables and indexed views...

It's a good question.

It's a bit shocking to see that so far out of just over 600 people about 55 people picked the non-existent and utterly implausible DBCC CHECKCACHE, and...

ChrisM@Work (7/31/2013)

---

Ensis

PHYData DBA (7/30/2013)

---

Thierry,

That explanation is not correct for TSQL. Style does not...

SQLRNNR (7/29/2013)

---

Jeff Moden (7/29/2013)

---

I just took a look at the home page for the first time this morning. Why in the hell do people think that change is always...

Nice question. Pity there was no reference in the explanation to anything that supported the answer 12 rather than 14, but as it's shown up in the discussion I...