Compare SEQUENCE cache size, restart gaps, rollback gaps, and insert throughput with CACHE 50, CACHE 1000, and NO CACHE.
SQL SERVER – How to ALTER CONSTRAINT
Can you ALTER CONSTRAINT in SQL Server? No. The only way to change a constraint is to drop it and create it again, and here is the script for that.
SQL SERVER – Prevent Constraint to Allow NULL
Why does a CHECK constraint allow NULL? A reader thought it was a bug. I show why it happens and how to write the constraint so NULL is rejected too.
Resumable ADD CONSTRAINT in SQL Server 2022: Pausing a Primary Key Build
Use resumable ADD CONSTRAINT in SQL Server 2022 to pause a key build, inspect progress, resume safely, and understand abort behavior.
Tagging With a Many-to-Many Table: Storing and Querying Hashtags
Store hashtags in a tag and bridge table, normalize input, query any or all requested tags, and count weekly trends without scans.
Stop Blaming the User: Let Constraints Catch Bad Data
Blaming the user is the oldest joke in IT. Here’s why it fails, and how NOT NULL, CHECK, UNIQUE and foreign keys stop bad data before it lands.
SQL Error Riddles: Parent Keys Not Found and Other Classics
SQL error riddles have been passed around for years. Here are the classics, told kindly, with the real SQL Server error behind each punchline.