If I recall correctly, "store password with reversible encryption" is used when the domain has NT 4.0 RAS servers. Use of that policy is considered dangerous.

Off the top of...

That reminds me of what motivational speaker Doug Wead said:

"If you don't have any horses, your barn will be clean."

):-D

If you have Server 2003, perhaps you could run the experiment and report back to us. NT version 5.2 and version 6.0 should behave the same with respect to...

Yes, I expected only

Complexity, and

Minimum Length

policies to be checked by CHECK_POLICY.

However, in my experiments, with a SQL Server login having only CHECK_POLICY in effect (but not CHECK_EXPIRATION), when minimum age...

The sqlcmd reference says that a file from a previous sqlcmd will be overwritten. So please tell me the syntax you were referring to that would append to the...

I agree with Hugo.

Another poorly worded answer. C'mon, I teach this stuff and know it. I want my point.

Yes, I'm being a crybaby. I still want my...

For soft skill acquisition, nothing beats Toastmasters.

):-D

Thank you, Anirban and David.

):-D

I suppose one could test whether the implicit conversion has a cost by creating a table with several million rows and running the query each way.

Unfortunately, I'm too busy (translation:...

Thank you.

I myself have trouble noticing everything in the questions! (LOL)

I did give an AdventureWorks example so people could actually test for the result.

):-D

True.

And I explicitly said "2005" in the body of the question.

):-D

I was very careful to specify SQL 2005 because SQL 2000 behaves differently.

I was inspired to post this question because one of my students used WHERE = 'true'...

Hugo is almost correct.

He put in one byte for the nulls. None of the columns allow nulls.

I get a maximum length of 319.

4 - row header

...

I want my point.

Please do a better job of proofreading your questions.

):-D

The second query would give a reasonable answer if you use 365.25 instead of 365.

The third query will not work if DOB is, for example, Feb 7 1987 and the...