EXECUTE

Question

EXECUTE

Viewing 10 posts - 16 through 24 (of 24 total)

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

mtassin SSC-Insane Points: 23099 More actions · Answer 1

Stewart "Arturius" Campbell (2/14/2013)
Good back-to-basics question, thanks Lokesh

+1. Had to think for a second about it... which is about all I have in thinking power today anyway. 🙂

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

Rich Mechaber SSChampion Points: 11130 More actions · Answer 2

Good question, had to think a bit.

Stupid me, scratching my head: what is that extra "databasename#" argument doing there?

I always use the (unnecessary) "As" when aliasing columns, b/c otherwise I..... scratch my head reading code. 😀

Rich

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 3

Great question to end the week and go into a three-day weekend. Thanks.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

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

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 5

Iulian -207023

SSCertifiable

Points: 7639

February 16, 2013 at 10:53 am

#1588610

Thanks for that

Iulian

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 6

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Revenant SSC-Forever Points: 42467 More actions · Answer 7

A good quetion, although I had to make an (educated?) guess.

Thanks, Lokesh!

sqlnaive SSCoach Points: 17437 More actions · Answer 8

Good question. I just guessed that it could be the case and bingo. I was on right track. 🙂

manik_anu SSCrazy Points: 2377 More actions · Answer 9

nice question.... 🙂

Manik

Go fast as possible

Manik
You cannot get to the top by sitting on your bottom.

sqlcentral-bugmenot SSC Enthusiast Points: 120 More actions · Answer 10

I am proud of my "wrong" answer - I answered correctly despite cleary seeing the question was missing an assumption. Who in their right minds would work on an instance having an AdventureWorks2008 database unless coerced forcibly?