Problem
Bad statistics can cause poor query performance and should be updated periodically.
Some examples of symptoms:
When the Timeclock form is opened it lags and Crows Nest stops responding
...
and the current employees records never load
The MR Queue on the Purchasing form times out and doesn’t load
Solution
From your Crows Nest server, launch Microsoft SQL Server Management Studio (SSMS).
Expand the Databases folder, right-click the CrowsNest database and choose New Query.
Copy & paste the query below into the new query.
Code Block language sql exec sp_updatestats
Click ‘Execute’.
After a few moments, you should see ‘Query executed successfully' at the bottom of your
SSMS window.
Right-Mouse-Click CrowsNest database and select ‘Properties’ from the context menu.
Select the ‘Options’ tool from ‘Select a page’ and ensure ‘Auto Create Statistics’ and
'Auto Update Statistics' are both set to ‘True’.
