Can you add an auto incremental identity column to a table after it is created? The answer is both no and yes, and I show the ALTER TABLE script.
SQL SERVER – GROUP BY Columns with XMLPATH – Comma Delimit Multiple Rows
How do you group by a column and comma delimit multiple rows of names into one value? It is a popular question, and I answer it with FOR XML PATH.
SQL SERVER – UPDATE FROM SELECT Statement with Condition
An old college friend asked how to UPDATE one table from another with a condition. Here is his sample and the UPDATE FROM SELECT statement that solves it.
SQL SERVER – SSMS: Resource Locking and Object Execution Statistics Report
How many times did a procedure run, and how much CPU and IO did it use? The SSMS Resource Locking and Object Execution Statistics reports answer exactly that.
Example of Delayed Durability: How Much Faster Are Commits?
This example of delayed durability runs 50,000 small transactions on SQL Server 2025 four ways and compares time and log writes. It shows what the database setting and the commit option change, and what you risk.
SQL SERVER – How to Setup Delayed Durability for SQL Server 2014?
How do you setup Delayed Durability in SQL Server 2014? Here are three methods, starting at the database level with ALTER DATABASE SET DELAYED_DURABILITY.
JSON_CONTAINS in SQL Server 2025: Searching Inside JSON Arrays
JSON_CONTAINS checks whether a JSON document holds a value at a path, including inside an array. This post tests it on SQL Server 2025: the json data type it needs, numbers versus text, case, NULL results and the older OPENJSON way.