I get it right, but I disagree with explanation:

If at least one 'Union' is used, duplicates will be removed from the entire final result set, no matter where the 'Union'...

What do you mean for "created and loaded database"?

Good, very good article!

Thank you!

🙂

I couldn't believe, it's too easy!

Same problem if you specify a subquery in the NOT IN clause instead of values.

If one row returned from the subquery contains NULL, the main query doesn't return rows.

SELECT *...

This script demonstrates some problem with implicit conversion:

declare @v-2 varchar(30)

,@f float

-- here you think it is all right and it is

...

This kind of error also is independent from version of sqlserver.

You can not use - * / operators with chars

Very good question.

I really really really learnt a new good feature.

Thank you a lot.

😛

Hugo Kornelis (2/22/2012)

---

Checked and confirmed that it works the same here.

What apparently happens is that SSMS gets all properties from the model database and uses them to pre-populate the properties...

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...