Collections:
What Is a SQL Server Partition
What Is a SQL Server Partition?
✍: FYIcenter.com
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.
2019-07-09, 1267🔥, 0💬
Popular Posts:
How to see my IP address Host Name? To help you to see your IP Address Host Name, FYIcenter.com has ...
How to valid UUID/GUID strings? In order to help your programming or testing tasks, FYIcenter.com ha...
Where to find tutorials on Test Management? I want to know how to manage software testing documents ...
How to validate Mod 10 (Luhn Algorithm) checksum? In order to help your programming or testing tasks...
How to convert IPv4 to IPv6 addresses? In order to help your programming or testing tasks, FYIcenter...