A trigger in SQL Server runs because something else happened, and you never call it. The inserted and deleted tables, why it fires once per statement and not once per row, and when to reach for something else.
What Is a Stored Procedure in SQL Server?
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.
SQL SERVER – Puzzle SET ANSI_NULLS and Resultset – SQL in Sixty Seconds #052
I take my puzzle to the next level with SET ANSI_NULLS OFF. Why do two different queries now return almost the same results? Watch the 60 second video.
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?