Partitioning tables in SQL Server provides improved query performance. Lets me share a simple example:- Imagine you have a large sales table with millions of records spanning several years.

<p>SQL Server supports table partitioning, whereby a table can be carved into as many as 15,000 pieces, with each residing on its own fi legroup. Each fi legroup can be independently backed up.