Why does SELECT * miss a new column? The adding column issue in view stays until you refresh it with sp_refreshview. Limitation of the view number 4.
Contained Database Users: Logins That Move With the Database
Use contained database users to move authentication with a database, inspect prerequisites, test connections, and review access ownership.
SQL SERVER – Index Created on View not Used Often – Limitation of the View 3
An Index Created on a view does not always stop queries from reading the base table. Limitation 3 of views, shown with a simple example.
SQL SERVER – Plan Cache – Retrieve and Remove – A Simple Script
A simple script to retrieve the plan cache for one query and remove just that plan, instead of clearing the whole cache on a busy server.
SQL SERVER – Does Order of Column in WHERE Clause Matter?
Does the Order of Column in WHERE Clause change a query plan? I invite a runnable example with a controlled comparison.
Spatial Indexes: Speeding Up Distance Searches
Use spatial indexes for geography distance searches, compare actual plans and reads, and inspect tessellation with built-in diagnostics.
CROSS APPLY Aggregate: An Empty Input Can Still Return a Row
CROSS APPLY aggregate behavior depends on whether the right-side query actually produces a row. I inspect that query before assuming unmatched customers disappear. An aggregate without GROUP BY can return a row even when its input is empty.