Category: SQL Server
-
Adding a Filegroup in SQL Server
In this post, we’ll demonstrate the process of adding a new filegroup to a database in SQL Server.…
-
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: Deleting Rows in Batches
Deleting a large amount of data from a SQL Server table can be a resource-intensive task. Whether it’s…
-
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…
-
Create a Test Database in SQL Server
As a SQL Server DBA and blogger, creating a test database with data often needed for preparing tests…
Most Viewed
Blog Categories
- Other (7)
- PowerShell (29)
- SQL Server (62)
- WSL (11)