This issue is one that has always bothered me. I wanted to devote a small amount of time every week to fixing small annoying bugs, instead of working on the...

Nice question, thanks!

I'm surprised after all the recent questions that were related that we still have ~25% answering this one incorrectly.

Nice question, thanks! I do find it interesting that they combined rounding and truncating in one function...

I saw the missing GROUP BY as well, but since the error option was specific to a different error, I just assumed it got left out somehow. Other than that,...

Thanks for the question!

Thanks for the great question, and the discussion!

Great question thanks!

This is a very good topic to cover, as I know a lot of developers don't understand the importance of specifying the size. (Good old VB "String" type.)

Nice question, thanks!

But for the record it is spelled deprecated not depreciated.

Are you using SQL Server 2008 or newer?

Bradley Deem (8/4/2010)[hrActually, with Coalesce it comes down to the expression with the highest data type precedence being returned, thus exactly 1 predictable type will be returned. Consider the...

Nice question thanks!

Though instead of your explanation I mights say "While ISNULL returns that value with the type of the first parameter COALESCE returns the value with they type of...

Nice question thanks! (It is nice to know that the issues I have run into in the past have taught me some things, and that I still remember them.)

Nice question, thanks!

I like having a theme day on the QotD to help raise awareness of the new features. thanks!

Jason,

What you looked at was "Snapshot Backups", not "Database Snapshots."

I think these are the ones he was talking about: http://msdn.microsoft.com/en-us/library/ms189940.aspx (Native standard features that don't require third party stuff.)

Interesting...