Chapter 15: Managing Large Tables and Databases

by Wayne Sheffield
  • Jason Brimhall
  • Jonathan Gennick
  • Wayne Sheffield

Abstract

Very large tables (where you have row counts in the tens of millions) have special needs. All data manipulations and maintenance operations need special considerations. This chapter will deal with features in SQL Server that can help; specifically, I’ll cover how partitioning a table can ease data movements and how the use of filegroups and data compression can help you improve performance by distributing data I/O across multiple drives and having a smaller amount of data to store on disk.

Keywords

Partition Function Partition Scheme Partition Number Large Table Data Page 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Jason Brimhall, Jonathan Gennick, and Wayne Sheffield 2015

Authors and Affiliations

  • Jason Brimhall
    • 1
  • Jonathan Gennick
    • 1
  • Wayne Sheffield
    • 1
  1. 1.UTUS

Personalised recommendations