T-SQL Logic

Question

T-SQL Logic

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

Trey Staker SSCarpal Tunnel Points: 4796 More actions · Answer 1

Thanks for the question. At first glance it looked like it was going to be really difficult/complicated but ended up being simple and fun.

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum

john.arnott SSChampion Points: 11882 More actions · Answer 2

OCTom (6/22/2010)
And the point is?... lost on me... again.:w00t:

Yes, it was relatively simple to analyze, but some of the QOD's should be at an elementary level. Not all members of this community are seasoned DBAs or developers.

As a note, I often try, as I did this time, to predict an answer from the copy of the question in the email newsletter, before seeing the multiple choices. That approach does crank up a few extra brain cells.

Henrico, thanks for submitting this one. I'm taking a reminder here that sometimes it's best to break down a problem first and see if a simple component (ID < 2) will give the answer without having to delve into the complicated other parts. It's like those math riddles which have all sorts of strange stuff and end up with the anwer being zero: ((ln 23 / (19^16))*((2^3)-(64^0.5))

Dan Guzman - Not the MVP Hall of Fame Points: 3757 More actions · Answer 3

I chose option 4 because I didn't know that there were no negative DB ID's. It would not be unlike MS to use negative ID's for system objects.

Now I know.

UMG Developer SSChampion Points: 13482 More actions · Answer 4

Interesting question, but I don't know that I would expect everyone to have the system DB IDs memorized. (Or even to know that DBs have IDs.) But given some basic understanding of the ID information the answer was very easy to pick out.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Thanks for the Question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Grumpy DBA SSChampion Points: 12515 More actions · Answer 6

Huh... I thought I chose "1" but it says I answered the question wrong... what's up with that?

Wayne Evans-440401 Ten Centuries Points: 1017 More actions · Answer 7

Interesting one. The explanation given isn't quite correct:

2. len(case name when 'master' then 'other' else 'name' end) > 4 --only the length of 'master' > 4, all other db's are changed to 'name', which length =4.

its not the len of the word 'master' being compaired, but the lenth of the word 'other'.

Wayne

Did you get access denied? Great the security works.

ken.trock SSCertifiable Points: 5147 More actions · Answer 8

Take out "and database_id < 2"; you still get the same result and looks like a harder question.

Ken