Kenneth,

I can understand that point. I am not going to say that you are wrong but I will offer my interpretation of the question and how I answered.

I took...

Definitely a poorly worded question. In addition to the reasons stated above, why would you have 'version(s)' and (choose 3) in the same sentence. :hehe:

The first and second answers were correct for me. The third answer was definitely wrong in my case. :hehe:

Steve,

I just wanted to echo some of the other posters and say I really enjoy the podcast.

It is definitely part of my morning routine right after QotD.

I...

Here is something I am curious about.

Setting the option for sync with backup on the distribution database has no effect on latency by itself.

Setting the option for sync with...

I understand that answer 1 implies both settings are active at the same time. However, if you answer 'both of these' one would wonder how that's wrong save for redundancy....

If synonyms were inherently schemabound then the following event would be true:

-you create a schema (mytable) based on test.table1

-you attempt to delete test.table1

-error fires and says you can't do it...

I feel the question could have been worded better. Specifically, I am referring to this sentence:

Which one of the following things that is not usually used to improve data warehouse...

I personally didn't think the question was too ambiguous. That is only my opinion. Searching BOL you can quickly find this:

Note:

You cannot reference a synonym that is located...

Yelena Varshal,

My coworker's BOL said the same thing that yours did.

My BOL did not say that. We checked our versions and his is

older than mine. My BOL page...

Thanks rgriffin. That article was quick and easy to read.

I'm not sure if this helps anyone but I found this article.

I've never done it this way myself.

http://msdn2.microsoft.com/en-us/library/ms136093.aspx

This may help some.

The Database Engine saves the settings of SET QUOTED_IDENTIFIER and SET ANSI_NULLS when a view is created. These original settings are used to parse the view when...

I answered correctly, but this almost threw me off:

The undo phase, which is the first part of recovery, rolls back any uncommitted transactions and makes the database available to users....

They ought to make one pass a simple grammar test prior to submitting a QotD. :hehe: