Fundamentals of Table Expressions, Part 11 – Views, Modification Considerations Itzik Ben-Gan returns to his table expressions series, covering what you need to think about when using a view to modify its underlying table(s). Itzik Ben-Gan ◆ September 8, 2021 0
Fundamentals of table expressions, Part 10 – Views, SELECT *, and DDL changes Continuing his series on table expressions, Itzik Ben-Gan explains why it is a bad idea to use SELECT * in views. Itzik Ben-Gan ◆ July 14, 2021 0
Fundamentals of table expressions, Part 9 – Views, compared with derived tables and CTEs Itzik resumes his series on table expression fundamentals, this time comparing views to CTEs and derived tables. Itzik Ben-Gan ◆ June 9, 2021 2
The Problem with Window Functions and Views Paul White dissects a few execution plans and explains why SQL Server can sometimes have problems optimizing views that incorporate window functions. Paul White ◆ March 20, 2013 9
If you are using indexed views and MERGE, please read this! Here is some information about an important MERGE "wrong results" bug, involving indexed views, that could be affecting the accuracy of your queries right now, and what options you have for working around the problem. Aaron Bertrand ◆ February 6, 2013 6