Title:
SQL-Server-processing-mass-data
Download
- Category:
- SQL Server
- Tags:
-
- File Size:
- 46kb
- Update:
- 2012-11-26
- Downloads:
- 0 Times
- Uploaded by:
- hua9527an
Description: Large size of the database is often hundreds of GB, and sometimes even use the TB calculation. The single-table data often reach hundreds of millions of records, and records will increase with time. This not only affects the operating efficiency of the database, but also increases the difficulty of maintaining the database. In addition to the amount of data table, the table different access patterns may also affect the performance and availability. These problems can be a reasonable partitioning of large tables has been greatly improved. When the tables and indexes become very large, the data can be partitioned into smaller, more manageable parts to improve the efficiency of the system.
To Search:
File list (Check if you may need any files):
SQL Server 2005利用分区处理海量数据.mht
