A Closer Look at "Statistics" in an SQL Server Sense--And Why They're So Important to Microsoft Dynamics NAV Users

There is the proverb "Never trust a statistic which you haven't faked yourself". Well, as SQL Server is as human as the next guy, this saying applies quite well ...

But what are these ominous statistics and what they are used for? The official definition for "statistics" in a SQL Server sense is: "Statistics for query optimization are objects that contain statistical information about the distribution of values in one or more columns of a table or indexed view".

...

Requires FREE Membership to View

Login
Become a Member Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more, and it’s all FREE. You’ll also receive periodic email newsletters with the latest relevant articles and content updates.
About Jörg A. Stryk

Jörg A. Stryk has worked with Microsoft Dynamics NAV since 1997, version 1.20.

Being project-manager, consultant, administrator, developer or supporter on Microsoft partner-sites and NAV customer-sites, he has thoroughly explored nearly all areas of the application and its technology.

Since 2003 he is focusing on "Dynamics NAV & SQL Server Performance Optimization and Troubleshooting", founding his company "STRYK System Improvement" in 2006. As a freelance consultant, he is supporting Microsoft Dynamics partners and customers with their NAV/SQL projects worldwide.

His book "The NAV/SQL Performance Field Guide" (ISBN 978-3-8370-1442-6) is published in Europe, the United Kingdom and North America.

In recognition of his valuable participation in various NAV communities, he received the Microsoft award "Most Valuable Professional" (MVP) for MS Dynamics NAV in 2007, 2008 and 2009.

Read full bio...