Home Forums SQL Server 2005 Business Intelligence Foreign key constraints in data warehouses RE: Foreign key constraints in data warehouses
TangoVictor
SSChampion
Points: 10969
More actions
July 9, 2010 at 9:19 am
#1190868
we use standard edition so partioning is not possible. And yes maint is easier. also we use schemas to separate all the dim data for security purposes and organization.