Perth SQL Server User Group

We have meetings once a month on a Thursday at the Microsoft Office at Level 3, 100 St George's Terrace.

We use EventBrite for meeting registrations - check out for a list of our previous events. Anyone is welcome to register, but please let us know at the meeting if you want to be added to the mailing list so you get email notifications of upcoming events.

We are always looking for local speakers, so if you want to try your hand at presenting feel free to let us know!

-- Jenny



Topic: The Power Of Composite Indexes
Date: Thursday, 22nd October, 5.00pm-7.00pm

Rob Farley


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.

Speaker Bio:

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 and is on Twitter at @rob_farley.