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.

Author

Daren Bieniek Mentor, Solid Quality Learning Daren Bieniek (daren@SolidQualityLearning.com), a mentor with Solid Quality Learning, has 20 years of professional technical experience, and he has done just about every role there is from system administrator to developer to architect. Over the past 10 years Daren has focused on data-related roles and technologies with a key emphasis on Very Large Database architecture, design, and implementation.
Vendor:
EMC Corporation
Posted:
02 May 2006
Published
01 Mar 2006
Format:
PDF
Length:
6 Page(s)
Type:
White Paper
Language:
English
Already a Bitpipe member? Login here

Download this White Paper!

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy