Good Question Didn't know anything about NEW Broker until now.

Simple & excellent question. Learned about permissions

Learned about Truncate when Foreign key ref. is available

Educated Guess

Simple & Easy

Good Question. Explanation clears all the doubts

Good Question. and very good follow up threads by some members. it clears some lack of answer explanations.

Query 1 is reliable while 4th one is the fastest...

I would have thought that Ans is true because we can specify color in connection properties

Awesome Question...

Nice Question. logged back after a long time and got it wrong. :sick:

Great one....

Good Question.

I found this link on google which explains it bit more in details

http://www.sql-server-performance.com/articles/per/temp_tables_vs_variables_p1.aspx

Great Question.

i thought ans would be 5 2 3 but as it wasn't present i have to search and found that space is ignored

would have been better if we have option...