GitHub

stored-procedures-database-engine.md

description: Learn how a stored procedure in SQL Server is a group of one or more Transact-SQL statements or a reference to a .NET Framework common runtime language method. [!INCLUDE [SQL Server Azure ...
GitHub

Stored-Procedures-SQL-Server

This GitHub repository was created for the blog post "What is stored procedure?" in Medium, and this repository contains two tables named User and UserBankAccount. The structure of the tables are ...
Microsoft

Using Natively Compiled Stored Procedures in SQL Server 2014

The new In-Memory OLTP feature in SQL Server 2014 greatly optimizes the performance of certain OLTP applications. By using the new memory-optimized tables you can speed up data access, in particular ...
TechRepublic

Determine when to use stored procedures vs. SQL in the code

Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one is best for your particular situation. I once was pulled into a discussion about the ...
TechRepublic

Understanding roles in SQL Server security

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...