O'Reilly logo

Inside Microsoft® SQL Server® 2008: T-SQL Querying by Lubor Kollar Itzik Ben-Gan Dejan Sarka, and Steve Kass

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required