A stored procedure is SQL with a name, a door and a contract. Why granting EXECUTE beats granting table access, what parameters buy you, and the plan reuse story people get half right.
What Is a Transaction in SQL Server?
A transaction in SQL Server is a group of changes that all happen or none do. A rollback that undid 16,440 rows, what ACID means in four short words, and the open transaction that quietly fills a drive.
TABLESAMPLE Samples Pages, Not Rows: Sampling a Large Table Right
Compare TABLESAMPLE page sampling with NEWID sorting and CHECKSUM filters by row count, reads, spread, and repeatability.
ANSI_NULLS Puzzle and NULL in SQL Server: SQL in Sixty Seconds #052
This ANSI_NULLS puzzle starts with two queries that look alike, and only one returns a row. The tests here explain the NULL logic behind IN and NOT IN, show what SET ANSI_NULLS OFF still does on SQL Server 2025, and give a safer pattern for real queries.
SQL SERVER- Solution – SQL Puzzle of SET ANSI_NULL
The solution to my Puzzle of SET ANSI_NULL: why IN returns a row but NOT IN returns nothing when the list has a NULL, and how SET ANSI_NULLS ON explains it.
SQL SERVER – How to use xp_sscanf in Real World Scenario?
I came across the extended stored procedure xp_sscanf and could not find a real world use for it. Here is how it works. Can you tell me where to use it?
CONCAT_NULL_YIELDS_NULL and CONCAT: How NULL Behaves in Strings
The CONCAT_NULL_YIELDS_NULL setting decides whether a string plus NULL returns NULL. The CONCAT function never looks at it and treats NULL as an empty string. This post tests both on a customer table, shows the errors the OFF setting causes, and gives safe patterns for names and numbers.






