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, 6997🔥, 1💬
Popular Posts:
How to Open and Close Internet Explorer with UFT script? One way to open and close Internet Explorer...
In what order thread groups are executed in JMeter? Thread groups, including regular "Thread Groups"...
How to generate test fractional numbers? Test fractional numbers are numbers with fractions that are...
Where to find test data generators? FYIcenter.com has prepared a number of test data generators for ...
How to valid UUID/GUID strings? In order to help your programming or testing tasks, FYIcenter.com ha...