SQL Server Table Partitioning with Dan Guzman 06-13-2023
Автор: St. Louis SQL Server and Business Intelligence UG
Загружено: 2023-06-15
Просмотров: 573
Content:
SQL Server table and index partitioning improves manageability of very large tables and facilitates nearly instantaneous load/purge/archive processes with partition-level operations. However, table partitioning may also introduce query performance regression when not used wisely. This session reviews table partitioning architecture, strategies, best practices, common gotchas, and mistakes.
Dan Guzman
Dan's been using SQL Server since version 4.21 was introduced on Windows NT and has over 30 years of database administration, development, and architect roles. He answers questions on StackOverflow, StackExchange, and Microsoft Q&A forums, speaks at user group meetings and conferences on database topics, and has received 18 Microsoft Data Platform MVP awards since 2001.
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
