Get back to fundamentals DBAs!
Article review: Fundamentals of SQL Server Statistics by Esat Erkec. Erkec is a SQL Server professional who began his career 8+ years ago as a Software Developer and he is a SQL Server Microsoft Certified Solutions Expert.
Erkec’s article is excellent at explaining the fundamentals of SQL Server statistics.
Points discussed by Erkec:
- Statistics play a key role in SQL query performance
- Auto Create Statistics option of the database can be enabled
- Commands to view SQL query statistics
- Detailed example with a SQL query plan
- Outdated SQL Server statistics
- SQL Query optimizer rules to update statistics
- Trace flag 8757
- SQL Query Recompilation reasons
- Use extended events with watch live data option
Ok DBA colleagues, get back to fundamental basics of SQL Server statistics when you find that onery query you are trying to optimize. Erkec offers a few ways to attack and resolve those queries when SQL Server statistics are not looking good.
I give the article “Fundamentals of SQL Server Statistics” by Esat Erkec a thumbs up.
This blog post first appeared on Retireddba.com: https://retireddba.com/
Gif is provided by Giphy.com.
Search for additional blog posts:
Ad
Pluralsight – Start your Free Trial today! – Don’t let technology outpace you. Work smarter and master your craft with a technology learning platform that will help you build better and create more.
Whizlabs – Online Training for Agile Certified Practitioner (PMI ACP)® Certification Exam | Enroll Now
ed2go – Creating Mobile Apps with HTML5
Pluralsight – Get your Skill IQ with a Free Assessment from PluralSight
RetiredDBA.com is compensated if you click to an advertiser website and/or you make a purchase after clicking to an advertiser website. This does not INCREASE the price you pay. The income is used to continue to provide as much free content as possible.
