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
