Indexes get fragmented as data grows. I asked my friend Tim Radney what he does then, and here are his index fragmentation next steps from the field.
MSDTC and Distributed Transactions Across Linked Servers
Understand MSDTC for linked-server transactions, inspect RPC promotion settings, diagnose coordination errors, and compare simpler designs.
Performance Statistic Collection: Notes from the Field #018
Good tuning starts with good numbers. In Notes from the Field #018, David Klee explains performance statistic collection and how DBAs should gather server data.
Storing Images in varbinary(max): Size, Reads and Backups
Store images in varbinary(max), read file bytes with OPENROWSET, inspect LOB allocation, and evaluate backup and retrieval costs.
Running SQL Server on an Azure Virtual Machine
SQL Server on an Azure virtual machine keeps instance control while moving storage and hosting to Azure; learn disk, backup, and sizing checks.
Querying Nested JSON Arrays With OPENJSON
Query nested JSON arrays with OPENJSON, preserve element positions, pass inner arrays with AS JSON, and handle missing or strict paths.
Indexing JSON Properties With Computed Columns
Improve indexing JSON properties with typed computed columns, matching paths, required SET options, and plan checks on your workload.