Maximum Row Size and Query Hints

In my last post (yes, that was two months ago), I gave an example of how a query hint could cause a query to fail.  In this post, I’ll give another example of how query hints can cause problems.  As with my last post, this post was inspired by a question submitted by a reader….


Implied Predicates and Query Hints

In this post, I want to take a look at how two seemingly unrelated features of SQL Server can interact to cause a problem.  The idea for this post came from a question submitted by a reader.  Let’s begin.  Consider the following trivial schema and query: CREATE TABLE T1 (A INT, B INT)CREATE TABLE T2…