This was already a good idea back in the 1960s. Of course people had to communicate by telex or paper mail back then, but it was already known that involving...

trubolotta (3/16/2010)

---

While I find the discussion of how to best use the getdate() function interesting, I also find it distressing that the pursuit of code efficiency brushes aside the more...

Robert Frasca (3/15/2010)

---

One of the reasons I don't like de-normalization in the OLTP database is that the business intent of the logical data model can become obfuscated by the perceived...

Gilles Willard (3/15/2010)

---

Maybe this is due to my lack of experience, or the fact that it's been several years since I last studied database normalization, but:

It seems to me that...

GSquared (3/15/2010)

---

Since it's a minor need and non-trivial change to how the T-SQL engine would parse out DDL commands, I wouldn't expect Microsoft to act on it with any alacrity....

This is an awful mess, isn't it? Should it be 50 and 16 or 50 and 50?

Well, actually, no: it depends whether the platform the instances are to be...

I'm going to be pedantic here, I'm afraid.

The cryptoAPI name for the MD2 hash algorithm is not MD2, but CALG_MD2 (http://msdn.microsoft.com/en-us/library/ms904264.aspx). So MD2 is NOT the cryptoAPI name for...

It's a pity that the correct answer (login using DAC and set the default database and language for that login back to what they were before) isn't available.

I assumed...

Me too - I went straight from 2000 to 2008 so had only book knowlege...

I think that's a pretty fair statement.

As that option wasn't available, I...

What a fun question. One option that looks irrelevant given the topic, one that looks obviously wrong, and one using a feature I'd never heard of. That last...

The ability to fix..with the click of a button: shouldn't that be qualified with "sometimes"? Without the qualification, does it mean "always" - in which case isn't it...

vk-kirov (6/16/2009)

---

What about CAST/CONVERT? These functions are scalar, built-in; XML data type can...

Joy Smith San (8/26/2009)

---

Good question.

I am able to understand why snapshot cannot be created on TEMPDB. But don't understand why it has been prohibited for Master and Model (Though it's...

Oh :blush:! I answered "which of the queries posted below ;doesn't; return...";-).

I guess I'd forgotten what the question was by the time I worked out what each...