Search Arguments
SARG or Search Arguments are very important for a good query, even if the predicate is very selective and supported
Month: May 2013
Temporary Tables
Sometimes we need to use temporary tables to do aggregations, joins or to simplify the job. SQL Server supports a
The Meaning of “Set-Based”
The term set-based is used to describe an approach to handle querying tasks and is based on principles from the
Execution Plan
Why I started my blog with some posts about query optimizer, execution plans and logical processing? Well, before you learn
