SQL Server: Renaming Indexes using the sp_rename Procedure
Not so long ago, I was working on a project where we needed to change the data type of a table. The...
How to Rename a Table Name in SQL Server
One of the most critical database administrator’s duties is managing database objects. For instance, the application logic changes,...
Configure SQL Jobs in SQL Server using T-SQL
SQL Server Agent is a component used for the database tasks automation. For instance, we need to perform Index maintenance on Production...
How to Write Stored Procedures for Professional SSRS Reports
In this article, we’ll talk about professional SQL Server Reporting Services reports, how to...
Parameter Sniffing Primer
Introduction Developers are often told to use stored procedures in order to avoid the so-called ad hoc queries which can result in...
Simplifying Unit Testing Main Stored Procedure Which Also Calls a Utility Procedure
This article provides a walkthrough of database unit testing a stored procedure which contains a utility procedure within it. In this...
Passing Data table as Parameter to Stored Procedures
Real-world database applications need to make multiple requests from the front end to the database...
SQL Server – Dissect the Internals of sp_spaceused
This article is an effort to dissect the output of the sp_spaceused stored procedure. Introduction Understanding the database usage...
