Essentials Guide to Table Partitioning and Data Lifecycle Management

Essentials Guide to Table Partitioning and Data Lifecycle Management

Cover
Databases are becoming more difficult to manage. As a result, Database professionals find themselves having to work with tables that are many GBs in size, if not Terabytes.

Managing these large databases and tables requires variations to the way to best manage a database. To compensate for the increased size of tables, Microsoft has introduced native table partitioning capabilities in SQL Server 2005 Enterprise Edition, which allow DBAs to work with partitions, or pieces of tables, that are much easier to manage than large, monolithic tables.

Read this white paper to learn how SQL Server 2005 Enterprise Edition, allows companies to take advantage of partitioning to provide improvements to maintenance and performance, and provide the necessary infrastructure for tiered storage of data.

Vendor:
EMC Corporation
Posted:
Feb 8, 2021
Published:
Mar 1, 2006
Format:
PDF
Type:
White Paper
Already a Bitpipe member? Log in here

Download this White Paper!