No matter whether you want to split tables vertically or horizontally, you can easily get a headache. In this session, Rob Farley explores reasons you might want to split tables, some of the performance pain you can suffer from, and some of the ways you can help mitigate it. Whether you’re thinking about partitioned tables or partitioned views, using a single filegroup or many, even using SQL DW versus SQL DB or SQL Server, this session may raise a few eyebrows.
About the presenter
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 to large PDW implementations. His presentation style and his ability to explain complex concepts simply are known throughout the SQL Server community. He blogs at http://sqlblog.com/blogs/rob_farley and at http://sqlperformance.com/author/robfarley and is on Twitter at @rob_farley.