SQL INSERT Takes 30x Longer than it Should

INSERT etc - SQL Server would crumble if it would have to compile everything all the time. Yet a thing may matter is whether the database is in simple or forced parameterisation. In the latter case, SQL Server replaces all constants in the query ...

social.technet.microsoft.com