#TSQL2sday : I wish SQL Server had better Table Partitioning

For this month’s T-SQL Tuesday, Kevin Chant asked us to dream up our fantasy SQL Server feature.

The feature I wish we had is Table Partitioning, but… Better. Unfortunately, the feature by large remained the same way since its release in 2005, without any meaningful improvements (besides some parallelism and statistics maintenance improvements).

But I think Microsoft can do much better. Continue reading #TSQL2sday : I wish SQL Server had better Table Partitioning