Scripts Archives - DBA Mantra

By using this site, you agree to the Privacy Policy and Terms of Use.

DBA Stuff Performance Tuning Scripts SQL Server

SQL Server Query Store: A Complete Guide for DBAs

Enabling and Using Query Store in SQL Server As a SQL Server DBA, the Query Store is one of the...

BY Technical Editor
August 20, 2025
0 Comment

Permission & Security Scripts SQL Server

How to Setup SQL Server Audit using SQL scripts

Navigating the complexities of SQL Server auditing can be daunting. Whether you’re ensuring compliance, securing data, or simply looking to...

BY Technical Editor
April 13, 2024
0 Comment

Scripts SQL Server

SQL Query to check port number of SQL Server

We can use below query to check the port on which SQL Server is listening. DECLARE @InstanceName nvarchar(50) DECLARE @value...

BY Editor
February 9, 2023
0 Comment

DBA Stuff Performance Tuning Scripts

How to capture SQL Server blocking information

Many a times Application team report SQL Server Blocking issues. In this article I will explain about Blocking and Its...

BY Technical Editor
August 12, 2016
2 Comments

Scripts SQL Server

How to move Indexes (Cluster and Non Cluster) from Primary...

As a DBA, many times there are requirements to segregate data in a Database into multiple file groups. There can...

BY Technical Editor
March 4, 2016
0 Comment

Scripts SQL Server

How to create Drop and Recreate Script of all Indexes...

It’s a general requirement in the DBA job to scripts out the database objects and deployment the scripts in the...

BY Technical Editor
March 4, 2016
0 Comment