MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article, I will try to give information about displaying Stored Procedure parameters in SQL Server in detail. In SQL Server, in some cases, you may want to view the Stored Procedure parameters in detail. You can easily do this using the code below. SELECT ‘Parameter_name’ =...
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...
Hello everyone, In this article, I will provide information about the procedure that brings the previous week’s list of failed logins in SQL Server. It is also very important for security to track failed login attempts to SQL Server. With the help of the procedure below, you can also track...
Hello everyone, In this article, I will give information about data compression procedure for all tables in SQL Server. There are two types of data compression. Row Level Data Compression: A compression method that converts fixed-length data types to variable-length data types and frees up free space. It also saves...
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...
Hello everyone, In this article, I will give information about what are the Differences Between Function and Procedure in SQL Server. This question especially comes to mind of curious friends who are just learning SQL Server. This question may come up in job interviews. It is useful to know briefly,...
Hello everyone, In this article, I will try to give information about finding the last used Stored Procedure in SQL Server. In SQL Server in some cases you may want to find the last used Stored Procedure. You can easily do this using the script below. SELECT DB_NAME(qt.[dbid]) AS [DatabaseName],...
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...