Pages and Extends Architecture The page is the fundamental unit of data storage in SQL Server. An extent is a
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
Nothing has change or will change, so we should make the change