Partitioning Tables in SQL SERVER
Partitioning is helpful for managing and accessing smaller chunks of data very efficiently and at a faster pace without compromising on data integrity.
SQL Server supports Range Partitions. This means that the partitioning is based on data ranges.