SARG or Search Arguments are very important for a good query, even if the predicate is very selective and supported
Sometimes we need to use temporary tables to do aggregations, joins or to simplify the job. SQL Server supports a
The term set-based is used to describe an approach to handle querying tasks and is based on principles from the
Why I started my blog with some posts about query optimizer, execution plans and logical processing? Well, before you learn
What Happens When a Query is Submitted? The main statement used to retrieve data in T-SQL is the SELECT statement.
By a “set” we mean any collection M into a whole of definite, distinct objects m (which are called the
Thinkins in sets is a great book by Joe Celko’s. This book tell us about concepts how we need to
Nothing has change or will change, so we should make the change