True or false: If you view the execution plan for a query against a partitioned view and see unnecessary partitions listed in the plan, you have probably discovered a bug and should call Microsoft.
What does an Executes column of 0 for a given query plan step indicate?
True or false: In order to ensure maximum query performance, the CHECK constraints that define the partition column for a partitioned view must not overlap.
Describe the purpose of the partitioning column in a partitioned view.
True or false: The SQL Server query optimizer can eliminate unneeded partitions from a query against a partitioned view at compile-time as well as at runtime.
True or false: Although it may be possible to force the optimizer to eliminate unneeded ...