All posts tagged:


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 – Logical Read – Viewing Missing Indexes – Note: Page views – 2,260 (before migrated from Dewalist Blog website on 08/08/2020)