Advertisement

Stored Procedures

  • Miguel Cebollero
  • Jay Natarajan
  • Michael Coles
Chapter

Abstract

Stored procedures (SPs) have been a part of T-SQL from the beginning. SPs provide a means for creating server-side subroutines written in T-SQL. SQL Server 2014 introduces the ability to natively compile an SP that accesses memory-optimized tables. The efficiencies gained with natively compiled SPs are an absolute game-changer in how you consider architecting an OLTP database solution.

Keywords

Small Disc Business Logic Query Execution Query Plan Machine Code 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Miguel Cebollero 2015

Authors and Affiliations

  • Miguel Cebollero
    • 1
  • Jay Natarajan
    • 1
  • Michael Coles
    • 1
  1. 1.ValricoUnited States

Personalised recommendations