Home
Essentials Guide to Table Partitioning and Data Lifecycle Management

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

Already a Bitpipe member? Login here

Download this White Paper!

Corporate E-mail Address:
You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

Please provide a Corporate E-mail Address.

This email address is already registered. Please login.

You have exceeded the maximum character limit.
First Name:
You forgot to provide your first name.

You have exceeded the maximum character limit.
Last Name:
You forgot to provide your last name.

You have exceeded the maximum character limit.
Company Name:
You forgot to provide a company name.

You have exceeded the maximum character limit.
Job Title:
You forgot to provide a job title.

You have exceeded the maximum character limit.
Seniority:
You forgot to select your seniority.
Job Function:
You forgot to select your job function.
# of employees:
You did not select the number of employees at your company.
Industry:
You did not select which industry you are in.
You did not select which industry you are in.
Address 1:
You did not provide a full local address.

You have exceeded the maximum character limit.
Address 2:
You have exceeded the maximum character limit.
City/Town:
You did not provide a full local address.

You have exceeded the maximum character limit.
Country:
You did not select the country you are from.
State/Province:

You did not provide a full local address.
Zip/Postal Code:
You did not provide a full local address.

You have exceeded the maximum character limit.
Phone:
You forgot to provide a phone number.

This phone number format is not recognized. Please check the country and number.

You have exceeded the maximum character limit.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.