SQL Server has many undocumented functions and commands. I will write series of posts with functions to have a library online.
The most common and widely used index that we know are nonclustered index. These indexes are created using the famous
Data types and Precedence of convert types SQL Server associates columns, expressions, variables, and parameters with data types. Data types
Logical Structures How, where, when you need to think in data storage? Well, this is the first step after you modeling
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.