Page Comparison

...

When the Timeclock form is opened it lags and Crows Nest stops responding.

Solution

...

1. From your Crows Nest server, launch Microsoft SQL Server Management Studio (SSMS).
   

   Image Added

2. Expand the Databases folder, right-click the CrowsNest database and choose New Query.
   

   Image Added

3. Copy & paste the query below into the new query.

   Code Block
   language sql
   exec sp_updatestats

   Image Added

4. Click ‘Execute’.
   

   Image Added

5. After a few moments, you should see ‘Query executed successfully' at the bottom of your
   SSMS window.
   

   Image Added

6. Right-Mouse-Click CrowsNest database and select ‘Properties’ from the context menu.
   

   Image Added

   
   

7. Select the ‘Options’ tool from ‘Select a page’ and ensure ‘Auto Create Statistics’ and
   'Auto Update Statistics' are both set to ‘True’.
   

   Image Added