THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Denis Gobo

SQL Champ - A Quiz to Prove Your SQL Knowlege

In case you are bored CodeProject has a small SQL test (7 questions)

Take the test here: SQL Champ - A Quiz to Prove Your SQL Knowledge 

And did you get everything correct?

And yes they wrote Knowlege instead of Knowledge  :-)

Published Tuesday, April 1, 2008 9:15 PM by Denis Gobo
Filed under:



andyleonard said:

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

:{> Andy

April 2, 2008 7:38 AM

Adam Machanic said:

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...

April 2, 2008 9:46 AM

Alex Kuznetsov said:

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?

April 2, 2008 11:38 AM

Denis Gobo said:

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)

April 2, 2008 11:53 AM

Kalen Delaney said:

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.


April 2, 2008 8:25 PM

mkkkkokop said:


February 3, 2011 5:35 AM

ap said:


January 29, 2012 1:43 AM

. said:


January 29, 2012 2:03 AM
New Comments to this post are disabled

About Denis Gobo

I was born in Croatia in 1970, when I was one I moved to Amsterdam (and yes Ajax is THE team in Holland) and finally in 1993 I came to the US. I have lived in New York City for a bunch of years and currently live in Princeton, New Jersey with my wife and 3 kids. I work for Dow Jones as a Database architect in the indexes department, one drawback: since our data goes back all the way to May 1896 I cannot use smalldates ;-( I have been working with SQL server since version 6.5 and compared to all the other bloggers here I am a n00b. Some of you might know me from or even from some of the newsgroups where I go by the name Denis the SQL Menace If you are a Tek-Tips user then you might know me by the name SQLDenis, I am one of the guys answering SQL Questions in the SQL Programming forum.

This Blog


Privacy Statement