I'd love to see an article showing a real world application of switching partitions.

I understand it would be great for historical data that can be archived by a date field,...

A code showing a unique filtered index would be like this:

CREATE UNIQUE NONCLUSTERED INDEX UX_TableName_Field ON dbo.TableName(Field)

WHERE Field IS NOT NULL;

Best regards,

I have seen that technique of combining unique indexes with filtered indexes before and it's really great to be able to do that. Thanks for bringing it up.

I really like...

I have learned many many things from his articles and posts (and still am).

The man is a legend!

*offers beer*

Best regards,

I agree that it's a great question and I thank the author for it but could you please correct the code and allow us to answer it again? Maybe you...

I couldn't find 1 as the correct answer for the second SELECT so I chose the four options below:

- Insert into table dbo.cuss1 generates an error msg

- Insert into table...

Thank you for the question.

Had to think this one through because of the operators.

And the variable was just to mess with us? 😛

Best regards,

Nice easy question. Thank you.

I've got it right because I'm thinking that the sys.sysobjects view is created inside any databases as a duplicate object from the model database. But the...

Thank you for the detailed explanation, GilaMonster.

I will study your post a little more and you're right.

In the company I work for we don't have DBAs so it's basically us...

GilaMonster (9/7/2011)

---

If every page is full (not uncommon), adding a column could easily make every single page split because there won't be space on the full pages for the new...

Surely but almost 100% fragmentation? The table has only a few columns and any row doesn't even have 500 bytes each. Perhaps I'm missing an important point here? Would...

I couldn't test the code but it seems to me that the problem happens because you're using a subquery inside another subquery while the fields displayed in the error message...

archie flockhart (9/6/2011)

---

Actually, it may mean that most people have never tried using Order By in a subquery, and therefore don't know whether it will give an error or just...

I had problems with ORDER BY before so that wasn't hard for me.

Thank you for such a straightforward question about a very important subject.

Best regards,

honza.mf (9/4/2011)

---

codebyo (9/3/2011)

---

Which IE version? One should be very careful to post an answer referring to a specific application without an explicit version. Sorry but not all machines will have...