Our next meeting will be on the third Wednesday of the month. We use EventBrite for registrations, so please register at http://adssug201412.eventbrite.com.
Our next meeting is: Wed, Dec 17 2014 12:00 to 14:00 in Adelaide.
The Significance of Ordered Data
When data is ordered, powerful things can happen, leading to vastly improved performance. Not only does it allow particular values to be found quickly, but many internal operators in both SSIS and Execution Plans can benefit hugely. The problem is that ordering data can be costly, and cause blocking for data flows. In this talk, you will learn to spot the pain associated with unordered data, and see strategies to help you take data-ordering to the next level.
Speaker: Rob Farley
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 up to large PDW implementations. His presentation style and his insight into the complex made simple and profound make him unique in the SQL community, with or without his guitar. He blogs at http://sqlblog.com/blogs/rob_farley and is on Twitter at @rob_farley.