Partitioning Limits in SQL Server 2019

Creating a table with horizontal partitioning in SQL Server

During the planning phase I found out about the new partitioning feature in SQL Server 2005 and later editions of SQL Server. It is a vast topic with several associated operations and configurations involved. In this tip I will share what I learned about partitioning, show an example to implement horizontal table partitioning along with a comprehensive list of related benefits and considerations.

Partitioned Table and Index Strategies Using SQL Server 2008

The Microsoft SQL Server 2008 database software provides table partitioning to make such operations more manageable.

Configuring Replication for Partitioned Tables Using T-SQL

New author Michelle Ufford brings us an article that shows how you can replicate those partitioned tables in your environment.