From the course: Developing Microsoft SQL Server 2016 Databases
Join today to access over 25,500 courses taught by industry experts.
Partition large data tables - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
Partition large data tables
- When data tables get very large with records numbering in the millions, it might be beneficial to consider creating partition tables. Partition tables are tables that have been split up horizontally so that collections of records can be spread out across multiple hard drives. This is accomplished by leveraging SQL Server filegroups, which serve as the physical location or containers that store the database objects. By spreading a single table across several filegroups, that, themselves, are stored on separate hard drives, you can increase the performance of reads and writes on the tables, since those operations can be performed simultaneously across partitions. Further, it increases the performance of other maintenance tasks, since the single partition can be modified without locking the entire table. There are four steps to creating a partitioned table. First, create a filegroup or filegroups within the database that'll…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.