SQL Server Index Design Basics and Guidelines

SQL index overview and strategy

SQL Server indexes - series intro

Best practices to configure the index create memory setting in SQL Server

SQL Server Index Structure and Concepts

SQL Server Index Fill factor with a Performance Benchmark

Overview of SQL Server Clustered indexes

Designing effective SQL Server clustered indexes

SQL Server Query Execution Plans for beginners – Clustered Index Operators