Get Live Help
The process of compiling a stored procedure part way through that procedure's execution.
Referential Integrity ensures that foreign keys correctly map to primary keys. A referential constraint prevents the insertion or update of foreign keys for which there are no matching primary keys, by either preventing the deletion of primary keys if foreign keys exist, or deleting these foreign rows (DELETE CASCADE).
A major functional part of SQL Server. Responsible for the parsing and optimization of SQL requests, controls query plan execution, and processes row sets from the storage engine.