End of Support does not shut down SQL Server, but it changes security updates, fixes, and help; plan an exit before risk grows.
SQL SERVER – Index Created on View not Used Often – Limitation of the View 12
At my Hyderabad seminar someone asked: will an Index Created on a view be used when you query the view? Not always. Limitation 12 of views explained.
SQL SERVER – Activity Monitor and Performance Issue
A small story with a big moral about Activity Monitor and performance issue: a client left the tool open, and the monitor itself slowed the server down.
Finding Every Object That Uses a Column
Find an object that uses a column with dependency metadata and module text search, then check dynamic SQL and application code.
SQL SERVER – Finding Memory Pressure – External and Internal
A quick query to find external and internal memory pressure in SQL Server and see how much memory each memory type is using right now.
Page Density: The Fragmentation Number That Actually Slows Scans
Measure page density and fragmentation, compare scan reads around a test rebuild, and choose fill factor using workload evidence.
hierarchyid IsDescendantOf: A Node Includes Itself
hierarchyid IsDescendantOf tests membership in a subtree, including its root. These literal paths keep both compared nodes visible and distinguish self from a strict descendant.