A quick performance comparison of server side paging in SQL Server 2012, split into two tests, with a focus on the unnecessary IO reads that make paging costly.
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 the Business Says Is Not What the Business Wants
Let us discuss about What the Business Says Is Not What the Business Wants. Steve raised a very interesting question.
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 – 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.
Restoring a Sample Database to New Folders With RESTORE FILELISTONLY
Use RESTORE FILELISTONLY to map backup files to local folders, restore a separate sample copy, and verify its data and log paths.
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.










