Stored Procedure Boundaries

Variable Default Values to a Stored Procedure (SQL Spackle)

A way to assign variable and overrideable defaults to input parameters to an SP or FUNCTION using a configurations table.

SQL Server Stored Procedures and SET options

SET options on stored Procedures work a bit different when compared with ad-hoc queries. These differences in behavior are often overlooked when developing the procedures and generating deployment scripts. This mistake can lead to undesired behavior in the application.

Find the most executed stored procedure(s)

Find the most executed stored procedure(s).

Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions

Some companies put business or application logic in SQL Server using stored procedures, views and functions to return values to the calling applications or perform tasks. This is not unusual in companies that use the SQL Server layer to perform business tasks, such as finance operations, or incorporate application functionality into the programmability layer. Here's a tip to preserve secrecy on some procedures, views or functions in order to maintain security.

Find Stored Procedures and Functions That Reference Certain Tables

Find any code objects that interact with a given table/view, or call another given code object.

Using the SQL Server APP_NAME function to control stored procedure execution

In this tip we will look at one way to achieve control of stored procedures to ensure that reuse is for the intended purpose and changes do not break other applications that may be using this same code.

Last Accesses Stored Procedure

List of your Stored Procedures and when they were last accesses.

Re-compilation and Its effects on Performance

How recompilation does significantly affect on the execution time of SQL query and plummet or degrade the performance?

Stored Procedures Performance

This script summarizes the execution statistics of the stored procedures which was run on the current database in the last 7 days.