Using the Data Dictionary to find hidden data in SQL Server

Why I Avoid Database Hints: a followup

In an earlier blog post about database hints, I gave a number of reasons why I dont like to use hints in SQL queries. Today I wanted to follow up to share one situation where I think hints are OK, even necessary. As described very well in an article in an article by...