Partitioned Tables

Creating a table with horizontal partitioning in SQL Server

  • Article

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.

2009-07-23

4,028 reads

Blogs

Speaking about Latches & Spinlocks at the EightKB Online Conference

By

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

Speaking about Latches & Spinlocks at the EightKB Online Conference

By

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

SQL server Linux and SQLCMD

By

Following on from a previous blog post (https://blobeater.blog/2021/01/15/sql-server-linux/) on installing SQL Linux, a common...

Read the latest Blogs

Forums

Backup to AWS S3

By bmenate

We backup over the weekend our full backups to a backup server with a...

ispac file association broken

By kyagi.jo

I updated my visual studio 2019 recently, and when I try to double click...

Assigning user to Azure Active Directory enterprise application via python SDK

By navyasri

I have added slack to Azure Active Directory Enterprise application and running SSO. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Strange Code

See possible answers