Tag: sql server stored procedure

Get Your SQL Server Database Size with Ease: Stored Procedures in Action

Database administration, Memory Optimization

As popular as the cloud services are nowadays, there’s still a good chunk of on-premises...
Read More

Execute Dynamic Query in SQL Server

Database development, Statements, Stored Procedures

Dynamic SQL is a statement constructed and executed at runtime, usually containing dynamically generated SQL string parts, input...
Read More

How to Get Backup Status in SQL Server using Stored Procedure

Database development, Stored Procedures

Any SQL Server DBA (of course, this applies to all platforms) will agree that database backups are the most essential things for data...
Read More

Welcome Back the T-SQL Debugger with SQL Complete – SQL Debugger

Tools & technologies, Utilities & Extensions

When you develop large chunks of T-SQL code with the help of the SQL Server Management Studio tool,...
Read More