Our next meeting will be on the third Wednesday of the month. We use EventBrite for registrations, so please register at http://adssug201310.eventbrite.com.
Our next meeting is: Wed, Oct 09 2013 12:00 to 14:00 in Adelaide.
Table Expressions: So Much More Than CTEs
You use table expressions a lot but may not have given them much thought as a tool for query tuning. Whether to use simplifiable table expressions or materialized tables can be a significant consideration for large queries, and one that shouldn't be ignored. This session will teach you how SQL Server handles table expressions and how they impact important performance features such as joins and the shapes of execution plans. Understanding where, when, and why you should and shouldn't use them can improve your T-SQL in all kinds of ways.
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.