Stored Procedure Generation Script
This script produces scripts for all the stored procedures in a database.
2025-06-13
7 reads
Scripts
T-SQL Table Valued Function to compare Semantic Versions
Semantic versioning (SemVer) is a standardized system for labeling software releases using a three-part number—major, minor, and patch—optionally followed by pre-release labels and build metadata. Comparing semantic versions is complex because it requires handling both numeric and string components, as well as special precedence rules for pre-releases and stable versions. SQL Server’s hierarchyid data type is ideally suited for comparing the numeric parts of semantic versions, enabling efficient and accurate ordering without the pitfalls of string comparison or manual parsing.
2025-05-27
74 reads
Script-Drop Orphan users from SQL Server Database
This script will help to find orphan users on all databases and will remove them.
2025-05-20
68 reads
2025-05-06
181 reads
SQL Server Heath Check Script
This script runs a SQL server Health check for services, databases, Always On, replication, CDC job status.
2025-05-05
183 reads
fetch an execution plan from SQL Server's buffer cache
To fetch an execution plan from SQL Server's buffer cache (i.e., the in-memory cache of execution plans), you can query the dynamic management views (DMVs) that SQL Server exposes.
2025-04-30
58 reads
List the Databases To Which You Have Access
Explanation: sys.databases contains information about all databases on the SQL Server instance. • HAS_DBACCESS(name) = 1 filters out the databases you dont have access to. •ORDER BY name sorts the result alphabetically.
2025-03-04
197 reads
Database mdf & ldf files size, used space, Free space in MB
This script will help to get the Database mdf & ldf files size, used space, Free space in MB.
2025-02-27 (first published: 2025-02-25)
158 reads
T-SQL Script for Monitoring Database Size in SQL Server
This T-SQL script helps you monitor the size and status of all databases on your SQL Server instance, providing insights into space usage and performance.
2025-01-29 (first published: 2025-01-20)
681 reads
Table Index Size
This procedure gets current table and index sizes of particular database and stores it to tables.
2025-01-07
213 reads
Blogs
ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish
By Ed Elliott
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...
Beginner’s Guide: Create a File Organizer CLI Tool in Rust
Image from Afdhaluddin on ShutterstockCLI which is generally referred to as Command Line Interface...
The Third Sabbatical
By Steve Jones
I can’t believe I’ve been at Redgate long enough to get a third sabbatical....
Forums
How Many Can Be the Greatest
Comments posted to this topic are about the item How Many Can Be the...
Azure Database Watcher Monitoring
Hi, I’ve provisioned an Azure Database Watcher to monitor our 4 Azure SQL Managed...
Can You Ask for a Raise?
Comments posted to this topic are about the item Can You Ask for a...
Question of the Day
How Many Can Be the Greatest
I am trying to analyze a number of columns in a large table to determine the highest value for each row. In SQL Server 2022, we have the GREATEST function, which will return the greatest value from those columns passed in. How many columns can I include in an expression like this:
select GREATEST( col1, col2, col3, ...)See possible answers