Here you will find links to articles and resources concerned with SQL Server Administration
- SQL Server Configuration
- Generic
- CPU
- Memory Managment
- Physical Storage
- SAN Configuration – Disk Partitioning
- SAN Best Practices
- Should you store image files in SQL Server or the Filesystem?
- Disk Alignment Best Practice
- Monitoring Drive and Database Storage
- Muli-Tenant Data Architecture
- RAID Calculator
- Disk Performance Hands On – This is Part 8 in an ongoing series on disk performance from Kendal Van Dyke. Compares the various RAID levels.
- SQL Server Urban Legends Discussed – The number of threads per file myth.
- SQL Server 2000 I/O Basics
- Indexes
- Inside sys.dm_db_index_physical_stats
- Storage Internals of Non-Clustered Indexes
- T-SQL Tuesday #010: Little Known Index Facts – Shows how the clustering key is stored differently in UNIQUE and non-unique nonclustered indexes.
- Geek City: Nonclustered Index Keys
- SQL Server Clustering
- SQL Server Reference Diagrams