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.
geometry Collections: Read Members With STGeometryN
geometry Collections hold member shapes that STGeometryN can return individually. I extract a point and a line from one fixed collection. A third request deliberately exceeds its member count.
SQL SERVER – Index Created on View not Used Often – Observation of the View
When is an index created on view actually used? After showing it is often ignored, I demonstrate a condition where SQL Server uses it, including NOEXPAND.
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 – Server Side Paging in SQL Server 2012 – A Better Alternative
Server side paging in SQL Server 2012 is simpler with OFFSET and FETCH NEXT. I compare it with the older ROW_NUMBER and OVER method from SQL Server 2005/2008.
SQL SERVER – What is Page Life Expectancy (PLE) Counter
What is Page Life Expectancy (PLE)? A quick query to read it from sys.dm_os_performance_counters, the recommended minimum of 300 seconds, and what it means.
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.




