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, 6010🔥, 1💬
Popular Posts:
How to validate and decode MAC (Media Access Control) addresses? In order to help your programming o...
How to turn off HTTP response compression in SoapUI? HTTP response compression reduces the data size...
Why I am getting gzip compressed HTTP response in SoapUI? If you run a HTTP request for some Website...
How to validate email address format? In order to help your programming or testing tasks, FYIcenter....
What are date and time test values? Date and time test values are frequently needed in testing date ...