Users often confuse a CTE with a temp table, but a CTE works like a view, and a CTE can be updated just like one. Matthew Spieth’s tip, with my notes.
Soft Delete With an IsDeleted Column: Indexes, Views and Keys
Design soft delete with an IsDeleted flag, filtered unique keys and indexes, a live-row view, and a measured archive process.
Renaming a Column Safely Everywhere It Is Used
Renaming a column safely requires finding SQL and application references, applying sp_rename, refreshing modules, and testing every consumer.
SQL SERVER – SSMS Automatically Generates TOP (100) PERCENT in Query Designer
Why does Query Designer in SSMS keep adding TOP (100) PERCENT when you create a view? A forum question, the full scenario, and what is going on.
Updatable Views: When INSERT and UPDATE Work Through a View
A view is only a doorway to the table behind it. I show which writes get through, which get rejected, and why CHECK OPTION earns its place.
Time-Limited Access: Expiring Grants With a Valid-Until Column
A ValidUntil column does nothing by itself. Here is how to make the read path enforce it, with a demo you can run.
Indexed View Restrictions Quiz: Which Rule Blocks the Index?
This Indexed View Restrictions Quiz asks which rule stops a unique clustered index on a view. The answer is the LEFT OUTER JOIN. A tested script shows the error, the working view, and what happens when each required rule is missing.