Which stored procedure runs most often? My small SQL Server 2005 script finds the most used stored procedure, with execution count, worker time and calls per second.
Porting Stored Procedures Between Platforms
Porting stored procedures means preserving error, transaction, temporary-table, sequence, and date behavior instead of translating tokens.
SQL Server CLR: The Common Language Runtime Inside the Engine
SQL Server CLR means running .NET code, such as C# stored procedures, inside SQL Server. A diagram shows how the pieces fit, and why CLR helps with the cursors and loops that slow down T-SQL.
SSIS or T-SQL for a Simple Load
SSIS or T-SQL for a simple load depends on sources, transformations, logging, and operations; learn when a stored procedure is enough.
Writing Tests for Stored Procedures
Write tests for stored procedures with arrange, act, and assert steps in T-SQL, isolated data, and a repeatable check before every change.
SQL SERVER – Correct Syntax for Stored Procedure SP
What is the correct syntax for stored procedure code? Anything between BEGIN and END is part of the procedure, and anything after GO is not, as my examples show.
SQL SERVER – 2005 – List All Stored Procedure in Database
Want to see all stored procedure in database at once? Run SELECT * FROM sys.procedures. This simple query works only with SQL Server 2005.