It is worth mentioning that, since this article was first published, SQL Azure has received a lot of Microsoft's attention. We've started using it ourselves. Notice that Microsoft...

Everyone, please notice that I originally wrote and published this article over a year ago. I got a lot of feedback at the time about the "tone" of the...

Absolutely....

Herman van Midden (6/26/2014)

---

Great solution and interesting article. I see your point of view, but the world is not entirely black and white. I also think automated index maintenance is...

This response will be about the rant.

About unique constraints vs. unique indexes: there are such things as unique indexes that are not constraints. They do enforce uniqueness just as...

Thank you all for your feedback. I do apologize for the tone of the article; to some extent, it IS a rant. However, it is also an article...

I think the article I submitted recently provides this information. I include code examples for seeing both which indexes are being used and what indexes the server thinks need...