USE HINT and DISABLE_OPTIMIZED_NESTED_LOOP
One of the available algorithms to join two tables together in SQL Server is Nested Loops. The...
New Query Hints Including USE HINT in SQL Server 2016 SP
This article is an introduction to the query hint overview that appeared in SQL Server 2016 SP1. There are many different thoughts on using...
What Can Query Plan Tell?
Introduction SQL query describes the expected result, not the way to get the result. The set of specific steps the server must take to...