I chose the wrong answer cause I didn't read the question properly. Answered the number of rows returned instead of number of columns. Now I'm just posting to get my...

Atif Sheikh (5/9/2010)

---

Set ANSI_NULLS off / on changes the results.

By default in database settings it is set to OFF.

But in SSMS --> Tools --> Options, go to Query...

The result would depend on the database settings for ANSI_NULLS, if the database settings for ANSI_NULLS is set to ON, then the answer given is correct, but if it is...

I choose the right answer "False" but that's because of this statement:

Because I believe that stored procedures are only optimized when they are first run,...

Sorry, your explanation and answer is only valid for SQL 2000. SQL 2008 requires the time out value to be 0 for the query not to time out. Whilst I...

The posts saying if you set SET NOCOUNT ON or SET ROWCOUNT <any value> first is correct, you'll get 0,1 as the answer. unfortunately the question didn't mention anything about...

Whilst I totally understand it's a valid identifier, I just want to understand, does that query create a table with the name "#", or does it create a temporary table...

RESTORE...

Can I also point that the msdb database data file is Msdbdata.mdf and not msdb.mdf? Just being picky, theoretically the msdb.mdf answer should be incorrect then because sql server 2008...

Nice! I almost got tricked. If you had put

1 Test Policy 150000.00

2 Policy1 250000.00

3 0.00

in the answer, I would have chosen it, but because this answer doesn't exist, it...

While the intention was good (showing new features of SQL Server 2008), I give up on the equivalent vs. same wording. maybe this is an intentional trap that obviously 50%...

bitbucket (9/23/2008)

---

I would like to thank all who have commented. I have learned a little more to apply to any additional QOD that I may submit. Please note...

Either I read the BOL totally wrong, or you got the answer totally wrong.

The BOL (linked in your answer) says they are equivalent. Unless "equivalent" does not equal to "the...

for those of you who says .ldf is log file not data file, please read the question carefully, it asks for database file, not data file. .ldf forms a part...

ah, that explains now. thanks for picking that up. We sure find mistakes in BOL (how scary to think how often we refer to it!)