Facility9

If you’d like to get in touch with me, visit my contact page. If you have questions about any of the material from the presentation, questions about any of the resource material, feel free to send me an email, send me an IM, or hit me up on twitter.

Indexes and Other Free Performance Boosts Presentation Materials

Rate this talk on SpeakerRate.com – Richmond Code Camp 2009.2

If you missed this presentation, or you want to see it again, or you just like the sound of my voice, you can view it here: Indexes and Other Free Performance Boosts (WMV Format).

Resources

How to tell if you have instant initialization enabled?

Disk Partition Alignment

Disk Partition Alignment (Sector Alignment): Make the Case: Save Hundreds of Thousands of Dollars – Jimmy May’s blog post on partition alignment

Disk Partition Alignment Best Practices for SQL Server SQL CAT Whitepaper by Jimmy May and Denny Lee

Indexing

Analyzing Your Indexes with a Custom Report Jason Strate’s

Index Selectivity and Column Order

Creating Indexed Views

Improving Performance with SQL Server 2008 Indexed Views

Statistics

What are statistics and why do we need them?

Index Statistics

Statistics Used by the Query Optimizer in Microsoft SQL Server 2008

Partitioning Data

Partitioned Tables and Indexes in SQL Server 2005

General Performance

Troubleshooting Performance Problems in SQL Server 2005

SQL Server Performance Tuning Links