What Is a SQL Server Partition


What Is a SQL Server Partition?

✍: FYIcenter.com


A SQL Server Partition represents a logical data storage space area that is used to store data for a table or other data objects.

By default all records in a table are stored in a single Partition.

You may configure a table as Partitioned with use multiple partitions, This may help to improve performance for large tables.

A Partition is allocated in a single logical Filegroup.

A Partition may be stored in multiple physical Files, if the Filegroup is defined with multiple physical Files.

SQL Server Partition information is stored in a system table called sys.partitions. Each record in this table represents a single SQL Server Data Partition.


What Is sys.partitions?


SQL Server System Views and Functions

⇑⇑ SQL Server Storage Tutorials

2019-07-09, 1320🔥, 0💬