Redundant indexes cost space and slow every write, but not every one can go. This post measures an index on Col1, Col2 next to an index on Col1, Col2, Col3 on SQL Server 2025: size, plan, reads and log bytes. It ends with a safe way to remove one.
SQL SERVER – Creating Database with Different Collation on Server
A client ran two instances on every server just for case sensitivity. Here is how to create a database with a different collation on the same server instead.
Take a Database Backup in SSMS: Step by Step
To take a database backup in SSMS, right-click the database, choose Tasks, then Back Up, and pick the backup type. This post walks through the dialog, shows the T-SQL that does the same work, explains the log backup error people meet first, and checks the files afterwards.
MERGE Performance for Large Upserts: UPDATE Then INSERT Instead
Is MERGE really slow, or did the rewrite just run on a quiet night? Here is a fair test you can run yourself.
Writing T-SQL With an AI Assistant: What to Check Before You Run It
Review T-SQL from an AI assistant for real columns, safe writes, index access, date boundaries, isolation, and rollback tests.
SQL Server Agent Basics
SQL Server Agent basics covers jobs, steps, schedules, proxies, and history so a first useful job runs with a clear owner and failure path.
A Calendar Table With Holidays for Date Math
Build a calendar table with weekdays, fiscal months, and American holiday flags, then count working days and find useful date boundaries.







