© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_16

16. Data Partitioning

Dmitri Korotkevitch

(1)Tampa, Florida, USA

The amount of data stored in relational databases is growing exponentially every year. Customers are collecting more data, and they are processing and retaining it for a longer amount of time. We, as database professionals, are working with databases that have become larger over time.

From a development standpoint, database size is not that critical. Non-optimized queries time out regardless of the database size. However, from a database-administration standpoint, the management of large databases introduces additional challenges. Data partitioning helps to address some of these challenges. ...

Get Pro SQL Server Internals, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.