What Is a SQL Server Partition

Q

What Is a SQL Server Partition?

✍: FYIcenter.com

A

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?

What Is OBJECT_ID()

SQL Server System Views and Functions

⇑⇑ SQL Server Storage Tutorials

2019-07-09, 116👍, 0💬