In the event where bulk inserts are required or validation of a constraint is not necessary, disabling and enabling foreign keys and/or check constraints can be extremely useful.
--Disabling Constraints
ALTER TABLE TableName
NOCHECK CONSTRAINT FK_TableName_ColumnName
GO
--Enabling Constraints
ALTER TABLE TableName
WITH CHECK CHECK CONSTRAINT FK_TableName_ColumnName
GO