Excellent QotD. Thanks Paul.

--

Kevin C.

Excellent question.

And thanks all for the additional information in your posts.

--

Kevin C.

I keep about a month's worth of backup both off-site and locally. Lucky for me, our databases are small 🙂

--

Kevin C.

Great question. Thanks. 🙂

Just so you know, Lynn, I appreciate your insights, especially on items such as the QotD.

I did find the answers a little ambiguous, but I learned a bit more about...

Once again, I learned something new. I had assumed that you needed a 'begin transaction' before you could rollback a transaction. I didn't know about ANSI_DEFAULTS also activating...

Nice question. Thanks.:-)

I don't have an explanation, but I did do some testing and learned that the same error occurs with .255, .355, .755, and .855, but does not occur for .055,...

It's a tough question.

My personal thought is, the English language being rather flexible in many instances, that we should define the context each time we need to explain it to...

Thank you Bitbucket for the excellent QoD.

Thank you everyone else for your excellent view points and comments.

I have learned much today not just about datetime and the two functions (getdate(),...

Well said (or written) Steve.

The QotD are a good chance to learn something and to test your knowledge. However, answering one is not required.:-D

Nice question. It really got me thinking (and on a Monday, too!):w00t:

Good question. It's always good to be reminded what the defaults are.

--

Kevin C.

I'm sure someone else can post it more elegantly, but here's a quick solution:

select cast(round(123.45 * 1.07,2) as money)

I based it off of slange-862761's suggestion of using cast in an...

I think that making security features (such as the encrypted client connection) default to ON would be smart for engines like SQL Server. Security practices often seem to come...