Search Arguments
SARG or Search Arguments are very important for a good query, even if the predicate is very selective and supported
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
Logical Query Processing
What Happens When a Query is Submitted? The main statement used to retrieve data in T-SQL is the SELECT statement.
Structured Query Language
By a “set” we mean any collection M into a whole of definite, distinct objects m (which are called the
Thinking in Sets
Thinkins in sets is a great book by Joe Celko’s. This book tell us about concepts how we need to
Start
Nothing has change or will change, so we should make the change
