THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search
Home Blogs Forums Roller Downloads   Opml View as RSS news feed in XML

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  :-)


Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!
Published Tuesday, April 01, 2008 9:15 PM by Denis Gobo
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

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.

~Kalen

April 2, 2008 8:25 PM
 

Log Buffer #91: a Carnival of the Vanities for DBAs said:

PingBack from http://www.pythian.com/blogs/908/log-buffer-91-a-carnival-of-the-vanities-for-dbas

April 4, 2008 12:52 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit

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 http://sqlservercode.blogspot.com/ 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

Syndication
©2006-2008 SQLblog.comTM
Brought to you by Peter DeBetta & Adam Machanic
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement