Everything You Always Wanted to Know about Data Partitioning but Were Afraid to Ask [DBA]
Duration: 2.5 hours
Data partitioning is the valuable technique that may dramatically simplify database administration and improve system availability and performance. Contrary to popular believe, it is not limited to partitioned tables and may be implemented with any version and edition of SQL Server.
This session will explain how to properly architect and implement data partitioning in your systems. You will learn the benefits and downsides of different data partitioning techniques and understand how to combine them together to get the most from the solution especially in the systems with the mixed workload.
You will see how data partitioning may help with the common tasks, such as implementation of the data purge with sliding window pattern; improving system availability and shorten the downtime with piecemeal restore; reducing index maintenance overhead; improving cardinality estimations on the large tables and several others.
Finally, the session will demonstrate how to address the issues that may arise with data partitioning and optimize queries against partitioned data.