Essentials Guide to Table Partitioning and Data Lifecycle Management
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