Target Audience: Some prior knowledge needed
Time: 10:00AM - 10:50AM
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.