THE SQL Server Blog Spot on the Web

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

Denis Gobo

Summer SQL Teaser #3 Three For The Price Of One

Since I am so munificent today I decided to have 3 teasers in this one post.


Teaser 1
What will be the output or error message if you would run this code?
-----------------------
DECLARE @ CHAR(2)

DECLARE @@ CHAR(1)

SELECT @ ='@@'

 

 

 

SELECT REPLACE(@,COALESCE(@@,NULLIF(@@ ,'@'),@@,'@','@@'),@)


Teaser 2
What will be the result of the following query?
-----------------------
DECLARE @i INT

SELECT @i = 100000

 

SELECT  @i*@i/@i


Teaser 3
What is the 5th isolation level in SQL Server 2000 and where can you find it
or
What is the 6th isolation level in SQL Server 2005/2008 and where can you find it?

These are the isolation levels you know with the SQL server versions in parentheses


READ UNCOMMITTED (2000 -2008)
READ COMMITTED (2000 -2008)
REPEATABLE READ (2000 -2008)
SERIALIZABLE (2000 -2008)

SNAPSHOT (2005 -2008)

BTW the READ_COMMITTED_SNAPSHOT option does NOT count

SPOILER For Teaser 3 below!!!!!

I decided to give the answer for this one since you can't just run the code to see it yourself

 

 

sql 2000

sql 2005/2008

 
 

It is in BOL by the way  ;-)

look for
DTS Package Properties (Advanced Tab)
DTSIsolationLevel
and
Configuring Properties for DTS Transactions

Chaos means anything goes, it is used to connect to other system which don't have the same isolation levels as SQL Server

Published Friday, June 15, 2007 5:47 AM 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

 

Denis Gobo said:

Decided to give the anwer for teaser 3

June 15, 2007 11:04 AM
 

Adam Machanic said:

Denis,

I don't believe that option actually does anything in SQL Server.  AFAIK, it's only there so that it can be used with other DBMSs--some of which actually do support it.

June 17, 2007 7:04 PM
 

Denis Gobo said:

True, I admit I have never used the Chaos isolation level.

I primarly deal with SQL Server, Sybase, flat files, Excel files and FoxPro(which thankfully has seen it last version from MS, no more exclusively locked files and other mambo-jumbo ;-)  )

June 18, 2007 4:43 AM

Leave a Comment

(required) 
(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

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement