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.
Advertisement
Amazon Prime Visa - Get a Amazon Gift Card instantly upon approval of Amazon Prime Visa
Chase Checking - Open your Chase checking account and get a bonus!
Chase Freedom Flex - Earn unlimited cash back with the Chase Freedom Flex credit card.
Chase Freedom Unlimited - Earn cash back with the Chase Freedom Unlimited credit card.
Chase Saphire - Open your Chase Saphire Preferred or Reserve and get bonus points and more!
Discover - Get a bonus when you open an eligible Discover account.
Marriott Bonvoy Credit card - Open your Marriott Bonvoy Credit card and get a new Cardmember bonus!
Rakuten - Sign up for Rakuten and earn cash back on your purchases at 3500+ stores. 20M+ members in the U.S. have earned over $3.2B in Cash Back at their favorite stores.
Schwab - Open a Schwab account and get up to $1,000 depending on your net deposit.
Xfinity - Open an Xfnity mobile or internet account and get a bonus