EADNUG June Meeting June 16, 2009

Our presenter this month is Kimberly Tripp who is a noted speaker, blogger, author, SQL Server MVP and Microsoft Regional Director. Learn more about her at SQLSkills.com.

Agenda:
6:00 to 6:30 Meet & Greet
6:30 to 8:30 (give or take) Kimberly's presentation
8:30 to 9:00 Q & A, Swag Giveaways and wrap-up

If you're like a lot of devs, you can do a decent job of designing your application's database, but when it needs more in the way of performance optimization, then you need a guru. Kimberly is that kind of guru. Kimberly's presentation topic abstract is:

Understanding Indexes and Fragmentation
Indexes are one of the most important items in terms of design and tuning. Understanding how indexes work, where the internal dependencies are and how fragmentation occurs are critical for all systems – from transaction processing to decision support. A system that has well-defined and well-maintained indexes will perform better and be more scalable as your data grows. Attend this session and get a deep look at how indexes work, what’s best to know in terms of design and creation and what’s important to do to fix fragmentation.

Understanding Query Processing (quick overview)
Finding a “good plan fast”

Understanding Selectivity and Statistics

Helping the Optimizer Optimize

Index Internals

Clustered index structure
Non-clustered index structure

Index Fragmentation

Defining Fragmentation
Detecting Fragmentation
Fixing Fragmentation

We should have some time for some Q & A at the end, so bring all your questions about the applicability of stored procs in this modern world of ORM's, the intracacies and evils of SQL Server transaction logs, what new goodness is in SQL Server 2008, and so forth.

We will have some pizza, soda and cookies (contributions to cover the cost are welcome but not required), so if you don't have time for dinner before you come, no worries.

See you there!