Tag: MSSQL DBA Tips
-
Why Use WHERE 1=2 in SQL
In my last post, we discussed the usefulness of WHERE 1=1 in SQL queries. This time, let’s explore…
-
WHERE 1=1 in SQL Queries
When delving into SQL queries, you may come across the puzzling WHERE clause condition: WHERE 1=1. This leaves…
-
SQL Server Script: Kill All User SPIDs
Database administrators often encounter scenarios where they need to terminate all user sessions or processes (SPIDs) in a…
-
SQL Server Script: Estimating Database Backup and Restore Times
In this post, you will find a SQL script designed to provide estimated completion times and detailed process…
-
SQL Server Script: Show Database Backup History
Explore this guide to retrieve crucial information on the last backup dates and times for all databases on…
-
SQL Server Script: Show Database Growth Events
Explore this script designed to reveal database and log file growth events within a SQL Server instance. This…
Most Viewed
Blog Categories
- Other (7)
- PowerShell (29)
- SQL Server (62)
- WSL (11)