A SQL Server database has grown to 5 TB.
Users complain that reports take over 20 minutes to load.
Explain how you would improve performance.
Discuss:
Index Optimization
Partitioning
Compression
Columnstore Indexes
Materialized Views
Query Optimization
Batch Processing
Archiving
Read Replicas