Adding check constraint to the partitioned table in SQL 2005 always scans ALL partitions
Yes. Even if constraint checks partitioning column and "bad" data can exist in one partition only. See for yourself: I create table natively partitioned on integer field with another char field to fill more pages (full script at the end…