RetiredDBA.com

RetiredDBA.com provides tidbits, ideas and insights to all things Microsoft SQL Server.

Home / SQL Server / Get back to fundamentals DBAs!

Get back to fundamentals DBAs!

/
/
/


giphy.com

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

Edureka – Enroll Now for Docker Training and Certification By Edureka and increase your chances to get hired by Top Tech Companies

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.


This div height required for enabling the sticky sidebar

Sponsor Ads



RetiredDBA Websites

ACTIVE
FOR SALE
Just OutletsChicago Job Resource
Retired DBALuxury Matters
Tradin Stuff
Value Buyers