Title: SQL Server Data Partitioning and Comparison

Tom Hanley

Target Audience: Some prior knowledge needed

Time: 10:00AM - 10:50AM

Track: Data

Room: 8

Data partitioning allows for the efficient loading, storage, retrieval, and shedding of data in an RDBMS platform. This session will focus on its use in SQL Server and how table partitioning can improve performance and decrease concerns over concurrency. We will also investigate approaches on the comparison of data using advanced topics like window functions. All of these ideas can help improve the performance of your SQL Server instance especially when using it as a data warehouse platform.