I have a big post in regards to some SQL settings/ best practices you should at least think about. Before posting that I wanted to get some feedback on the option called "Auto Create Statistics". In SQL Server Management Studio if you go to your NAV database, properties, options you should see a property called "Auto Create Statistics". It has been suggested by a well respected SQL DBA that we have this set to True. I believe the only reason ours is set to false is because of NAV on older versions (like the 5.0 or before) it was recommended to turn this off but can't really remember.
So my question to everybody is for a NAV 2018 database (or similar) what should "Auto Create Statistics" be set to?
------------------------------
Jason Wilder
Senior Application Developer
Stonewall Kitchen
York ME
------------------------------