sponsored by EMC Corporation
Posted:  02 May 2006
Published:  01 Mar 2006
Format:  PDF
Length:  6  Page(s)
Type:  White Paper
Language:  English
ABSTRACT:
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.



BROWSE RELATED RESOURCES
Data Migration | Database Management | ILM | Logical Partitions | Reporting Software | SQL Server | Tiered Storage

View All Resources sponsored by EMC Corporation

About TechTarget:

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines

All Rights Reserved, Copyright 2000 - 2014, TechTarget | Read our Privacy Statement