5121 Cottonwood St, Salt Lake City, UT
January SLC SQL Meeting - CR 3+4+5
Presentation by Rob Farley - Table-Splitting Headaches
Abstract: 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.