Summit 2009

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

• Performance Considerations of Data Types
• Overhead in Non-Unique Clustered Indexes

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

• One-to-Many Inserts with Table-Valued Parameters
• Bulk Inserts with XML
• BCP Basics