Stored Procedures

How to Rename a Table Name in SQL Server

10:56 Database development, SSMS, Stored Procedures, Tables

One of the most critical database administrator’s duties is managing database objects. For...
Read More

Configure SQL Jobs in SQL Server using T-SQL

10:44 Code Management, Database development, Stored Procedures, T-SQL

SQL Server Agent is a component used for the database tasks automation. For instance, we need to perform Index maintenance on Production...
Read More

How to Write Stored Procedures for Professional SSRS Reports

01:06 Business intelligence, Database development, SSRS, Stored Procedures

In this article, we’ll talk about professional SQL Server Reporting Services reports, how to create stored procedures for these reports...
Read More

Parameter Sniffing Primer

07:00 Database development, Stored Procedures

Introduction Developers are often told to use stored procedures in order to avoid the so-called ad...
Read More

Simplifying Unit Testing Main Stored Procedure Which Also Calls a Utility Procedure

15:17 Database development, Stored Procedures, Testing

This article provides a walkthrough of database unit testing a stored procedure which contains a utility procedure within it. In this...
Read More

Passing Data table as Parameter to Stored Procedures

14:10 Database administation, Stored Procedures, Work with data

Real-world database applications need to make multiple requests from the front end to the database in order to carry out all sorts of...
Read More

SQL Server – Dissect the Internals of sp_spaceused

17:43 Database development, Stored Procedures

This article is an effort to dissect the output of the sp_spaceused stored procedure. Introduction...
Read More