All posts tagged:

mssql

How to handle the slow query in SQL

As you find challenges in writing or maintaining database especially for SQL Server, here I found something that I either forget or don’t realise this. Challenges Facing this query that always returning more than 1 minutes to run. I am checking about the index and I didn’t see anything significant.…

SQL: Performance Tuning Query

Query: — Basic setup DBCC DROPCLEANBUFFERSDBCC FREEPROCCACHE SET STATISTICS IO ONSET STATISTICS TIME ON /* SELECT * FROM dbo.Categories*/ Useful Links: 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/ Note: Page views – 2,260 (before migrated from Dewalist Blog website on 08/08/2020)