Subscribe to our newsletter to get our newest articles instantly!
As you find challenges in writing or maintaining databases, especially for SQL Server, here I found something that I either forget or don’t realise. Challenge Facing this query that always returns more than 1 minute to run. I am checking about the index and I didn’t see anything significant. Solution When you join the table, […]
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 […]
