During the lifecycle of your data-tier applications, you may need to perform a number of maintenance tasks and performance optimizations against the tables that hold your application’s data. These operations may include partitioning a table, compressing a table, or migrating data to a memory-optimized table. In this chapter, we will explore these three concepts in detail.
© Peter A. Carter 2019P. A. CarterPro SQL Server 2019 Administrationhttps://doi.org/10.1007/978-1-4842-5089-1_7
7. Table Optimizations
Peter A. Carter1
Partitioning is a performance optimization for large tables and indexes that splits the object horizontally into smaller units. When the tables or indexes are subsequently accessed, SQL Server ...