9 best practices for faster SQL queries Retrieve only the columns you need Use CASE instead of UPDATE for conditional column updates Keep large-table queries to a minimum Pre-stage your data ...

Any table they reference cannot be dropped without first dropping all of the stored procedures that reference it. Unfortunately normal stored procedures don’t support this option in SQL Server 2014.

Basically, you’ll want to enable system-versioning for the source table to a history table which you’ve decided will be temporal. That being the case, you’ll need a couple additional columns of ...