10/13/2015 9:53:18 AM
This month we MOVED THE MEETING TO THURSDAY (AND EARLIER) so we can get a sneak preview of Rob Farley's USA PASS SUMMIT SESSION
A composite index is when an index key uses multiple columns. Yet we see countless third-party applications recommending single-column index keys. In this session, we will explore the benefits of both scenarios, and also look at the impact on query plans, performance, blocking operators, and coverage. We will take a deep dive into concepts such as sargability, index intersection, inequality operations, and methods for writing queries that can help you get the most out of your indexing strategies, whether using composite or non-composite indexes.
Rob Farley runs LobsterPot Solutions. He is an MCM, MVP, MCT, PDW Trainer, and proud Arsenal supporter. He spends a lot of his time either tuning queries or helping people with their BI systems, from small in-house data warehouses to large PDW implementations. His presentation style and his insight into the complex made simple and profound make him unique in the SQL Server community, with or without his guitar. He blogs at http://sqlblog.com/blogs/rob_farley and is on Twitter at @rob_farley
Venue: Mechanics School of Arts, Level 1, 280 Pitt St, Sydney |
Duration 5:00 pm Pizza and drinks | 5:30 pm - 7pm Session |
On: Thursday, October 15, 2015