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 ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
