Partitioning in SQL Server

It is hard to say exactly when partitioning was introduced in the SQL Server relational engine for the first time. Clever programmers can create a UNION ALL view over several SELECTs, each from one table. The tables can be, for example, daily customer transactions, and a new table is introduced and included in the view definition every day. Most people believe the first true partitioning was introduced by supporting partitioned tables and indexes without the need to use views in Microsoft SQL Server 2005. This may be true because the keyword PARTITION found its way into T-SQL syntax for the very first time in SQL Server 2005.

Partitioned Views

There are two orthogonal classifications of partitioned views. The first is ...

Get Inside Microsoft® SQL Server® 2008: T-SQL Querying now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.