2 min read
0
TSQL to find list of all index not used for last 30 days
This code is designed to provide information about the indexes…
Year: 2023
3 min read
1
Use ProcDump to capture sql server unexpected crash dump
To use ProcDump to capture a SQL Server unexpected crash…
2 min read
0
SQL Server (MSSQLSERVER) service terminated unexpectedly
One day, we suddenly discovered that the SQL Server was…
2 min read
1
TSQL to find index fragmentation in SQL Server
To determine index fragmentation in SQL Server, you can use…
3 min read
0
13 min read
0
6 min read
0
List all Login, User & DB Role in SQL Server
Description This script generates a list of Logins, Users and…
3 min read
0
How to check database encryption in sql server
Introduction Data security is a critical aspect of database management,…
1 min read
0
4 min read
0
Check SQL Server Version & license details
As a SQL Server DBA, I would rephrase the statement…