BrainDonor (2/22/2012)

---

However, try this through the SSMS GUID. If I change 'Database Read Only' to TRUE from the Properties and then right-click on 'Databases' to create a New Database, it...

I found this: http://msdn.microsoft.com/en-us/library/ms190249.aspx

It states that:

To change the default values for any one of the database options for all newly...

I think there's a BUG in the "Contribution Editor". I couldn't believe that so many questions are wrong.

😎

Steve, please correct the points and the "Contribution Editor".

+2

Hugo Kornelis (2/10/2012)

---

I hate questions where I have to second-guess the author. Did the author mean that the optimizer would choose to use the indexed view automatically? Or did he...

I know that query optimizer use index on view only for some edition, but with noexpand you can force the use of index. I still working with sql2000. In sql2008...

Steve Jones - SSC Editor (2/1/2012)

---

My apologies. I think I selected the wrong answer when reworking things. The original answers weren't quite clear, so I altered them.

I have fixed things,...

Hugo Kornelis (1/31/2012)

---

Meh, I don't like questions where people who really understand the subject have a 50/50 chance of getting it right because they have to second-guess the author's intention.

"Is...

+1

It seems too easy. So, I digged in deep on google and MSDN.

Thanks for the qotd. 😀

Another question "Please, my points back!"

WOW! First time, I answered right 10 qotd consecutively. 😀

I like qotd about new and/or particular feature.

Thanks!

😀

That's a good idea: a beefsteak of reindeer.

I'd like deepen the argument, but i've limited time.