Writing Faster SQL Presentation

This presentation walks through common steps a developer can take to write faster SQL statements.

It covers:

• Indexes!
• Sargability
• What to Index
• Including Columns
• Filtering Indexes
• Indexing Tips
• Matching Data Types
• Optional Parameters
• Finding Bad Queries
• EXISTS
• MERGE
• T-SQL Tips
• Set based processing
• Reducing Compiles
• Loading Data
• Deleting Data
• Asynchronous Patterns
• Caching

Download Writing Faster SQL Presentation