Question: What is Read Ahead Read in SQL Server?
Answer: This is SQL Server’s feature which brings data pages into the buffer cache.
Do Index Reorganization Update Statistics? – Interview Question of the Week #196
Question: Do Index Reorganization Update Statistics?
Answer: No. Index Reorganization does not update Statistics of your database.
First Queries to Run on an Unfamiliar SQL Server
Inspect an unfamiliar SQL Server with read-only queries for version, uptime, database size, waits, backup history, and settings.
Checking Optional Features Installed on an Instance From T-SQL
A 1 in SERVERPROPERTY does not mean the feature runs. Here is how I line up the flag, the setting and the service in one query.
Asynchronous Statistics Updates: When They Help and When They Hurt
Evaluate asynchronous statistics updates against compile latency, data-change timing, and low-priority metadata locking in SQL Server.
Intelligent Query Processing: Checking What Is On per Database
Check intelligent query processing by database compatibility level, scoped switches, and actual plan evidence before comparing servers.
Inline Table-Valued Functions: Parameterized Views That Stay Fast
Compare inline table-valued functions with scalar functions, preserve customer results, and inspect plans before claiming performance gains.