Use OFFSET FETCH with a unique sort order, compare early and deep page reads, and decide when a cursor based approach fits better.
SQL SERVER – Tomorrow 2 Sessions on Performance Tuning at TechEd India 2011 – March 25, 2011
Tomorrow at TechEd India 2011 in Bangalore I present two sessions: SQL Server Extended Events, and waits and queues for performance troubleshooting.
Statistics Histograms Explained
Statistics histograms explained through steps, RANGE_ROWS, EQ_ROWS, and DBCC SHOW_STATISTICS help connect data shape to plan estimates.
SQL SERVER – Summary of Month – Wait Stats and Wait Type – Day 28 of 28
The month of Wait Stats, Wait Types and Queues is complete. Here is the full list of all 28 posts, with thanks to the guest bloggers who joined the series.
SQL SERVER – Signal Wait Time Introduction with Simple Example – Wait Type – Day 2 of 28
When do wait stats occur? Day 2 explains the running, runnable and suspended states of a query and introduces signal wait time with a simple example.
SQL SERVER – Wait Stats – Wait Types – Wait Queues – Day 0 of 28
The index for my 28-day series on SQL Server wait types and wait queues, with links to every day from wait stats basics to CXPACKET and beyond.
SQL SERVER – Introduction to Wait Stats and Wait Types – Wait Type – Day 1 of 28
Day 1 of my 28-day series on wait stats and wait types: how reader feedback and six months of tuning work led me to share these real world findings.