Category: Stored Procedures

SQL Server Procedures articles and Procedure code examples

Seeing Procedure Execution Statistics in SQL Server

Hello to everyone, In this article, I will try to give information about seeing Procedure Execution Statistics in SQL Server. In SQL Server you may want to see Procedure Execution Statistics in some cases. One advantage of Stored Procedures is that performance can be tracked. There may be many Stored...

Removing All Procedures in SQL Server

Hello everyone, In this article, I will provide information on how to remove all procedures in SQL Server. In SQL Server we may want to remove all procedures in some cases. You can easily do this using the code below. DECLARE @procName VARCHAR(500); DECLARE cur CURSOR FOR SELECT [name] FROM...

Listing Disk Spaces in SQL Server

Hello everyone, In this article, I will talk about how to list disk spaces in SQL Server. In SQL Server, in some cases, it may be desired to display disk spaces with a query. In such cases, we can list the disk spaces using the following query. EXEC master..xp_fixeddrives; When...

Don`t copy text!