Next Meeting: Wed, Jun 03 2015
FoxPASS June 2015 Meeting
Event Type: In-Person & Online
Online Meeting URL: https://meet.lync.com/sqlpass365-sqlpass/fox/D04W17N7
Calling anyone who works with SQL Server indexes (that's you!)! Time to learn about index from Andy Yun!
Event Time : Wed, Jun 03 2015 17:30 - 19:30 Central Daylight Time
Your Local Time: Wed, Jun 03 2015 22:30 - 00:30
4351 W College Ave Suite 210
Direction: This is the Concordia University just off Hwy 41 & College Ave.
Cleaning House: The Indexing Edition
Andy Yun, Senior Database Architect/Developer Rise Health
Do you design your database's indexes? Well, have you ever analyzed how those indexes are being used, if at all? And do you know if SQL Server needs other indexes to improve performance? Attend this session and discover how SQL Server tracks actual index usage. We will use this data to identify wasteful, unused, & redundant indexes. Finally, we will dive into the Missing Index DMV and learn how to make proper use of its recommendations. We will spend the second half of this session interactively working through a demo exercise, to reinforce the entire process.
Once a DBA, Andy is a Database Architect & Developer. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, Andy strives to make T-SQL leaner and meaner. Passionate about passing his knowledge onto others, Andy actively participates in the SQL Server community, as co-Chapter Leader of the Chicago Suburban User Group, and by speaking at regional User Groups & SQL Saturdays.