SQL Server table partitioning – planning and implementation guidelines

Nowadays, the big environments that have large databases with a heavy amount of transaction they had one common performance issue in the OLTP transaction when the database size increased to the hundreds of gigabytes or more it will be difficult to load data. Microsoft SQL Server provides us table partitioning to make this OLTP operation … Continue reading SQL Server table partitioning – planning and implementation guidelines