SQL: Performance Tuning Query

Query:

— Basic setup

DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE

SET STATISTICS IO ON
SET STATISTICS TIME ON

/*
SELECT * FROM dbo.Categories
*/

Useful Links:

Performance Tuning in SQL Serverhttp://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/

Note: Page views – 2,260 (before migrated from Dewalist Blog website on 08/08/2020)