About the Presentation

Introduction to Performance Tuning

Everything I wish someone had told me when I started with SQL Server years ago. An overview of using profiler to capture events Clustered, non clustered, covering indexes, looking at query plans (rid lookup, key lookup, scans vs seeks) When to use a table variable vs temp table

Session Level: Beginner

Download Introduction to Performance Tuning.zip

Mike Femenella

I've been a Developer/DBA/Architect for 12 years. I've written a few articles for SQLTeam.com and currently work for Bank of America as an advisor to their Global Credit products team. I also hold SQLMonday's for Bank of America, working to educate our developers on "best practices" to improve code quality.

Contact URL: