Here you can find an assorted list of blog posts and external references pertaining to the presentation I gave at PASS Summit 2009. The presentation was entitled, “Super Bowl, Super Load – A Look at Performance Tuning for VLDB’s.”
Database Design
Partitioning Resources
- Partitioning Code Example
- Indexing for Partitioned Tables
- Partitioning Tricks
- Partitioned Tables and Indexes in SQL Server 2005 (White Paper by Kimberly Tripp)
Indexes
- Index Defrag Script v3.0
- Index Clean-Up Scripts
- A Look at Missing Indexes
- Filtered Indexes: What You Need To Know
- Find Missing Indexes in Stored Procs with T-SQL
Bulk Operations