-
Select Start > Microsoft SQL Server > SQL Server Management Studio.
-
Connect to the server.
-
In the Microsoft SQL Server Management Studio window, under the Object Explorer, select the server (top-level node), right-click, and on the shortcut menu, select New Query.
-
Enter the following SQL script with the name of your database, for example:
USE Site_Server1_DB
GO
EXEC SP_UPDATESTATSThis script updates the statistics for every table in the database.