How do you stop people from using SELECT * in views? A slow query in a Health Check came from SELECT * over a wide view, so here is one way to prevent it.
Inline Table-Valued Functions: Parameterized Views That Stay Fast
Compare inline table-valued functions with scalar functions, preserve customer results, and inspect plans before claiming performance gains.
SQL SERVER – View Column Dependencies and Output Columns
To Identify Columns used in a view, I distinguish references from returned output columns. Those lists answer different questions.
Stale Views: Why SELECT * Breaks After ALTER TABLE
Reproduce stale views after SELECT star and ALTER TABLE, find candidate definitions, refresh with sp_refreshview, and prevent the pattern.
SQL SERVER – CTE can be Updated
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.