When to use Indexing ProTools - Andy Mallon

Agenda:
6:00-6:30 - Networking and Appetizers - you can buy your own drinks and dinner from the bar if you like or just enjoy water and appetizers provided by our sponsor.
6:30-6:45 - Greetings and Announcements
6:45-8:00 - Feature presentation
8:00-9:00 - Questions and discussions

We are an informal group so the times may vary a bit from the schedule and please feel free to arrive anytime from 6:00 on and leave when you need to leave.

Here is this month's featured presentation:

When to use Indexing ProTools

Using the right index for the right scenario can be the "go fast" button that keeps queries and customers happy.

Over the years, Microsoft has given us many different indexing options and flavors. Today there are many more considerations beyond "clustered or non clustered". We'll cover all those different flavor options: Filtered, Compressed, Columnstore, included columns, and Partitioning.

We won't only talk about what these options are, we'll also cover how and when to use these different indexing options, and how to make sure you have enough--but not too many--indexes for your workload.

About Andy Mallon
Andy is a Data Platform MVP and SQL Server DBA that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. He has been supporting high-volume, highly-available OLTP environments with demanding performance needs since 2003.

Andy is the founder of the BostonSQL User Group, and previous co-organizer of SQL Saturday events in Boston. He blogs at am2.co, and as a guest blogger at SqlPerformance.com.

Andy lives just outside Boston, Massachusetts, USA with his husband and their two dogs.