Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Hints   (RSS)

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
Posted by craigfr | 0 Comments
Filed under: ,

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:
Posted by craigfr | 1 Comments
Filed under: ,
 
Page view tracker