SQL Champ - A Quiz to Prove Your SQL Knowlege

re: SQL Champ - A Quiz to Prove Your SQL Knowlege

andyleonard — Wed, 02 Apr 2008 11:38:37 GMT

That's cool Denis. Wouldn't you know it - I missed the one on SQLCLR.

:{> Andy

re: SQL Champ - A Quiz to Prove Your SQL Knowlege

Adam Machanic — Wed, 02 Apr 2008 13:46:31 GMT

Fun :-)

The answer to the question on Database Snapshots is wrong, according to Ron Talmage. Apparently he and the SQLCAT team tested under intense load and saw times when creating the snapshot could take hours...

re: SQL Champ - A Quiz to Prove Your SQL Knowlege

Alex Kuznetsov — Wed, 02 Apr 2008 15:38:50 GMT

Nice link Denis. Yet (as you know that we disagree on many things ;) ) I would not allow the following code in production:

cast(floor(cast(@MyDateTime as float)) as datetime)

I would use dateadd and datediff instead. I don't think such tricks with cast, floor, and datetime are relevant to writing production quality code. What do you think?

re: SQL Champ - A Quiz to Prove Your SQL Knowlege

Denis Gobo — Wed, 02 Apr 2008 15:53:00 GMT

Alex I agree, instead of

select cast(floor(cast(getdate() as float)) as datetime)

I would do

select dateadd(dd, datediff(dd, 0, getdate())+0, 0)

re: SQL Champ - A Quiz to Prove Your SQL Knowlege

Kalen Delaney — Thu, 03 Apr 2008 00:25:05 GMT

I would also take issue with the answer to the question on snapshots. The missing element is that SQL Server runs recovery on the snapshot so that all the data available through the snapshot is committed data. If you create a snapshot while the db is in the middle of (or not quite done with) some long transactions, it can take a long time to run recovery.

~Kalen

re: SQL Champ - A Quiz to Prove Your SQL Knowlege

mkkkkokop — Thu, 03 Feb 2011 10:35:04 GMT

bionnnn

re: SQL Champ - A Quiz to Prove Your SQL Knowlege

ap — Sun, 29 Jan 2012 06:43:30 GMT

tjhbvfg

re: SQL Champ - A Quiz to Prove Your SQL Knowlege

Sun, 29 Jan 2012 07:03:37 GMT

,.'/,.'