O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

Viewing Partition Information

One of the first things that many people like to do when creating partitions is to test them. It is easy to insert data into a partitioned table because partitioning is automatic. Since partitioning is native to SQL Server 2005, the data is automatically inserted into the correct partition. However, if you want proof that partitioning is working, you can use some of the queries that you will learn in this chapter. Partition information can be found with both SQL statements and SQL Server Management Studio.

Viewing Partition Information with SQL Statements

If you are like me, you’d like some sort of proof or indication that partitioning is really working. The following example demonstrates how you can create a partitioned ...

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