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.
About the presenter
Rob Farley works for LobsterPot Solutions, a MS Gold Partner consulting firm. He is a Microsoft Certified Master, Microsoft MVP (SQL Server), APS/PDW trainer and leader of the SQL User Group in Adelaide, Australia. Rob is a former director of PASS, and runs training courses around the world in SQL Server and BI topics.
This event is hosted by the Adelaide SQL Server User Group, and sponsored by LobsterPot Solutions
Join millions of people on Eventbrite.
In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.