Collections:
What Is sys.partitions?
What Is sys.partitions view in SQL Server?
✍: FYIcenter.com
sys.partitions is a system view in a SQL Server Database that contains information about each data partition used by a data object in the database.
Each record in the sys.partitions table represents a single data partition with the following key fields:
Here is a list of records from sys.partitions showing data partitions used in a SQL Server database:
SELECT * FROM sys.partitions partition_id object_id index_id partition_number hobt_id rows ... 103872 1 1 1 397632 8572 ... 300480 5 1 1 463168 1195 ... 824768 7 1 1 528704 1368 ... 890304 8 0 1 594240 20 ...
⇒ What Is sys.allocation_units
⇐ What Is a SQL Server Partition
2023-07-10, 5622🔥, 1💬
Popular Posts:
In what order thread groups are executed in JMeter? Thread groups, including regular "Thread Groups"...
How to valid IPv6 addresses? In order to help your programming or testing tasks, FYIcenter.com has d...
How to generate user birthday dates? Test user birthday dates are frequently needed in testing appli...
In what order thread groups are executed in JMeter? Thread groups, including regular "Thread Groups"...
How to generate MAC addresses? To help you to obtain some MAC addresses for testing purpose, FYIcent...