June Meeting

Tuesday, June 16, 2009, 6:00 PM

EWEB
500 E 4th Ave
Eugene, OR 97401
View Google Map

The June meeting has been moved to Tuesday the 16th to accommodate our presenter's travel schedule. We are still using the meeting room at EWEB (500 E. 4th Ave) in the north building (go under the skybridge at the plaza and look for EADNUG signs on the building that's, well, on the north side of the skybridge).

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.

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 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

About the Speaker

Our presenter 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 - 6:30  Meet & Greet
  • 6:30 - 8:30  Kimberly's Presentation
  • 8:30 - 9:00  Q & A, Swag Giveaways and wrap-up

We should have some time for some Q & A at the end, so come with all your questions about the applicability of stored procs in this modern world of ORM's, the intricacies 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.