SQL Server Authentication Modes and Demo

tempdb System Database importance and configuration

SQL Server Trouble Shooting using Single User Mode

Performance optimization using wait stats( an important technique for performance related issues)

Constant Folding (optimization of some constant expressions )

Select Query process & optimization through Database Engine

Query Optimization and Select Query Analysis

Select Query Operators and Logical Operators Precedence

Batch Model Execution (Query Execution Methods in Query Plan)

Query Execution Methods(Row Execution Method) in SQL Server

Alter Index Rebuild (Index maintenance method)

Comparison between Rebuild VS Reorganize Index method.

Alter Index Rebuild Demo using SQL Server management studio

Alter Index Reorganize Demo using SSMS.

Alter Index Reorganize(Index maintenance method)

Index Maintenance Methods

Low page density and its problems(index Performance Issue)

Low Page Density ( a big Index Performance Issue)

Demo of Index Fragmentation ( An Index Scan Problem)

Fragmentation problems in SQL Server index

logical/External Vs Internal Fragmentation in SQL Server Index

Fragmentation in SQL Server Index

Read-Ahead Demo (how it works in SQL Server using Index Scan)

Read-ahead mechanism for Index Scanning

Allocation Order Scans or Physical Scan in SQL Server Index Structure