Using stored procedures for performance benefit

These stored procedures must be run regularly for performance benefits:

• sp_updatestats - Run this SQL-supplied stored procedure regularly for statistics updating for all tables in a database. You can get more information about this stored procedure from the SQL online help.
• SLServerRestartSp - This stored procedure runs whenever the database server is restarted, since no one is logged in at that time, and performs general cleanup.
• PurgeNextKeysSp - Run this stored procedure to clean up the NextKeys table. NextKey records are inserted, never updated to get concurrency. This stored procedure cleans out the extra rows.
  Note: Do not run this utility while others are using the system. The utility will lock users out, but you should log everyone out of the system before running this utility.