Stay Tuned!

Subscribe to our newsletter to get our newest articles instantly!

Programming

SQL: Performance Tuning Query

  • 21 February 2010
  • 0 Comments

Queries — Basic setup DBCC DROPCLEANBUFFERSDBCC FREEPROCCACHE SET STATISTICS IO ONSET 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 […]