Queries

— Basic setup

DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE

SET STATISTICS IO ON
SET STATISTICS TIME ON

/*
SELECT * FROM dbo.Categories
*/

Sources

Performance Tuning in SQL Server – http://www.youtube.com/watch?v=P97_oFfD218

Logical Read – http://www.sql-server-performance.com/articles/per/logical_reads_p1.aspx

Viewing Missing Indexes – http://webbtechsolutions.com/2010/02/23/viewing-missing-indexes-in-management-studio-2005/

Credits

Photo by Panumas Nikhomkhai: https://www.pexels.com/photo/close-up-photo-of-mining-rig-1148820/

[Note: Page views – 2,260 – before migrated from the Dewalist Blog website on 08/08/2020]