Good One.

Nice discussion to follow up with the question.

thanks Steve that would be great.

Cheers

How can I get notified when it's available to general public for try before launch?

didn't know release dates of code name "Denali" and was sure about SQL 2008R2.

Agreed with other posts should have more SSRS Questions....

Excellent Question.... nice puzzling logic....

Thanks Michael

bitbucket-25253 (8/1/2011)

---

Dhruvesh Shah (8/1/2011)

---

My server got hang. but from memory i have setup my instance as US. Can some one pls advise how can i find out what's my default...

My server got hang. but from memory i have setup my instance as US. Can some one pls advise how can i find out what's my default country setting is?

Your query has BranchId as part of the where clause which eliminates resultset as a whole where BranchId is not 13. You have to include BranchId in your join to...

Wasn't easy one for me i had to google a bit.....but at the end got it right and will remember in future...

Correct Ans must be it depends on data. Also it does return same number of rows for given database. (zero)

Question is about how many rows returned and the ans should be 5. As query writes 5 values to the temporary table @tbl.

Following link from Microsoft doesn't give details about data center edition. but it does confirm that no other (other then enterprise edition) has database snapshot feature.

http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx%5B/url%5D

Cheers

Awesome question & diagnostics