While an abundance of unused indices are certainly worth taking care of, ther is an equally important task, namely the missing indices. This topic is covered here (external link).

But thank...

Nice little article.

Implementers must be aware that if you ask for too many addresses in this manner, Google will come after you, asking for money. The only way to get...

Carlos Sacristan (4/15/2010)

---

But what happens with the internal calls that a store procedure could make? For example, if sp_a calls sp_b, and sp_b is never called directly, you probably think...

Good to see examples of the output clause.

The @@identity problem should be a no-problem, if people just remembered to use scope_identity() instead. It will return the correct identity value to...

This problem also arises with views. If you do "select * from" within a view, you will get the column mismatching as well.

The select will fail if you have cut...