This Types of Triggers Quiz asks which trigger you can put on a view that joins two tables. The answer is INSTEAD OF INSERT. A tested script shows the error an AFTER trigger gives and how the working trigger splits one insert into two tables.
Indexed Views: When the Faster Reads Are Worth It
Evaluate indexed views by building a sales summary, comparing read savings with write maintenance, and using NOEXPAND where required.
Tabular Models for the SQL Developer
Tabular models for the SQL developer add relationships, measures, security, and reusable semantics above SQL tables; learn when a view is enough.
Summary Tables: Keeping Pre-Aggregated Totals Current
Keep summary tables current with changed-day rebuilds, handle late arrivals and deletes, and reconcile stored totals against detail.
SELECT * in Production Code: The Hidden Costs
See the real costs of SELECT * in production code: lost covering indexes, lookups, stale view metadata, broken inserts and wider results.
SQL SERVER – Get File Statistics Using fn_virtualfilestats
Which MDF or NDF file is the busiest? This query uses fn_virtualfilestats to show reads, writes, IO stalls and size for every database file.
SQL SERVER – Index Created on View not Used Often – Observation of the View – Part 2
A reader asked what happens when we create an index on the base table as well as on the view. Part 2 of my observation of the view looks at both cases.