I have a parent table with a column I want to drive partitioning off,
but the child tables, as you can guess don't have that same
information in them, hence a normalized database . Is there an
approach to add the same criteria for child tables in the same
partition? The only solution I could come up with is using an SSIS
package that would run every night and get a list of the criteria and
alter the scheme function. Anyone have other ideas?