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
Rob Farley from LobsterPot Solutions recently became a Microsoft Certified Master in SQL Server. He's also an MCT, an MVP (since 2006) and is a PASS Board member. He blogs at <a href="http://sqlblog.com/blogs/rob_farley">http://sqlblog.com/blogs/rob_farley</a>, tweets as <a href="https://twitter.com/rob_farley">@rob_farley</a>, and you can reach LobsterPot via <a href="http://lobsterpot.com.au">http://lobsterpot.com.au</a>
Download material about this presentation: seeks_scans.zip