Part 3 on how to retrieve TOP and BOTTOM rows together: Dave Arthur’s solution uses UNION ALL instead of an OR clause, and it is quite good.
Finding the Most Frequently Run Queries
Most frequently run queries can consume large SQL Server resources even when each call is fast; use plan cache and Query Store to find them.
SQL SERVER – SELECT 1 vs SELECT * – An Interesting Observation
SELECT 1 vs SELECT * inside IF EXISTS: I ran 4 tests and both gave the same result and the same execution plan cost. Can you find a case where they differ?
SQL SERVER – Introduction to Performance Monitor – How to Use Perfmon
How to use Perfmon: three ways to start Performance Monitor, how to add counters, and how to log them over time so you can compare later.
SQL SERVER – Introduction to Three Important Performance Counters
Three basic but very important Performance Counters: % Processor Time, Avg. Disk Queue Length and Disk Read and Write Bytes/sec, and what their values mean.







