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, 5728🔥, 1💬
Popular Posts:
How to find out my browser request headers? To help you to see your browser request headers, FYIcent...
How to Open and Close Internet Explorer with UFT script? One way to open and close Internet Explorer...
How to generate user birthday dates? Test user birthday dates are frequently needed in testing appli...
How to validate domain name format? In order to help your programming or testing tasks, FYIcenter.co...
How to perform UUDecode (Unix-to-Unix Decode)? UUEncode is Unix-to-Unix encoding used on Unix system...