When you delete data from a table, does SQL Server reduce its size? A page level look at index levels and delete operations, corrected with Hrvoje’s help.
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.
FOR JSON PATH: Choose Whether NULL Properties Appear
FOR JSON PATH omits NULL properties by default. Compare INCLUDE_NULL_VALUES with missing properties and empty strings in a complete output 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 – Adding Column is Expensive by Joining Table Outside View – Limitation of the Views Part 2
Need one more column from a view? Joining table outside view is expensive, and changing the view adds network traffic for every query. Views limitation part 2.
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.







