Our next meeting will be on the third Wednesday of the month. We use EventBrite for registrations, so please register at http://adssug201302.eventbrite.com.
Our next meeting is: Wed, Feb 20 2013 12:00 to 14:00 in Adelaide.
Why Scans are better than Seeks
Most DBAs design indexes and queries to avoid Scans and Lookups, and get adequate performance without knowing much more than that. In this talk, Rob Farley will demonstrate some of the differences between Scans and Seeks, breaking some of the preconceptions that people have about them, and investigating some of the impact they have around Joins, Parallelism and more. You'll see lots of queries and query plans, and leave with a much better understanding about what to look for in plans.
Speaker: Rob Farley
I'm turning 40 during the Summit! But don't tell anyone. Gifts are welcome, but I have to be able to take them through customs when I return to Adelaide, Australia, where I run LobsterPot Solutions. Something nice for the shelf next to my certificates for MCM, MCT and MVP (since 2006). I'll try to describe all my gifts on my blog at http://sqlblog.com/blogs/rob_farley or Twitter, as @rob_farley.
Download material about this presentation: seeks_scans.zip