Next Meeting: Wed, Jan 30 2013
Winnipeg SQL UG - January 2013
Event Type: In-Person
Online Meeting URL: None
Event Sponsor: Microsoft Canada - Pizza and drinks provided - Please do not forget to register so I have an accurate count for pizza
Event Time : Wed, Jan 30 2013 17:30 - 20:00 (UTC-06:00) Central Time (US & Canada)
210-233 Portage Avenue
Index-fu - getting the most out of your indexes
Michael DeFehr, Consultant MDD Solutions
So you know the difference between a clustered and a nonclustered index. I won't review it again - I promise. This session will focus on expanding your understanding of indexes and what you can use them for. We will look at the internals of how they are structured, included columns, filtered indexes and indexed views. We will explore how to use indexes to enforce contraints beyond just simple uniqueness. Earn your SQL Black belt with this fun and informative session.
Michael DeFehr is an independent SQL Server consultant based in Winnipeg, Canada. He is focused on database administration and development using Microsoft SQL Server.
A SQL Server MVP, Professional Engineer and MCITP in both Database Development and Administration, Mike has spent the past 15 years producing and maintaining database solutions. Mike specializes in the relational and storage engines and his solutions emphasize performance and simplicity.