Stay Tuned!

Subscribe to our newsletter to get our newest articles instantly!

Programming

SQL: Performance Tuning Query

Queries

— Basic setup

DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE

SET STATISTICS IO ON
SET STATISTICS TIME ON

/*
SELECT * FROM dbo.Categories
*/

Sources

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/

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 on 08/08/2020]

Avatar

Valdy

About Author

Valdy founded Dewacorp.com, a helpdesk and IT Services provider that has taken care of over 39,000 customer service requests in the past 15 years - that's nearly 2,600 per year. He also created the growing Dewalist.com - a classified website that has close to 55,000 page views and 6,000 user visits per month with 52,000 yearly published ads and 39,000 active registered users. He blogs for the ever-growing Dewapost.com, a tech blog that gets around 20,000 impressions per month with 700 clicks and 10 average pages first impressions on Google Search. You can reach him on the Contact Us page, social media links below or Dewachat.com.

You may also like

Programming

Notes: Road to Yii Framework

Apache2 Configuration on MAC Snow Leopard: /etc/apache2/httpd.conf “It worksP page is located under: /Library/WebServer/Documents/index.html.en To restart apache2 after changing: sudo apachectl
Programming

How to handle the slow query in SQL

As you find challenges in writing or maintaining databases, especially for SQL Server, here I found something that I either