Hash partitions in SQL Server

The HashBytes function in T-SQL

Table Partitioning in Azure SQL Database

How to use SQL Check Constraints

Constraints in SQL Server: SQL NOT NULL, UNIQUE and SQL PRIMARY KEY

Commonly used SQL Server Constraints: FOREIGN KEY, CHECK and DEFAULT

Internals of Physical Join Operators (Nested Loops Join, Hash Match Join & Merge Join) in SQL Server

SQL Server Execution Plan Operators - Part 3

Query Optimization Myths