Craig Freedman's SQL Server Blog

A discussion of query processing, query execution, and query plans in SQL Server.

Browse by Tags

Tagged Content List
  • Blog Post: 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. SQL Server has a documented...
  • Blog Post: 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...
Page 1 of 1 (2 items)