SytelineMaster

  1) Update Statistics You should always run the below command nightly Exec sp_updatestats 2) Rebuild Index for key tables It is worth to rebuild index for key tables regularly, like once a week. DBCC DBREINDEX (ledger) GO DBCC DBREINDEX (item) GO DBCC DBREINDEX (customer) GO DBCC DBREINDEX (matltran) GO DBCC DBREINDEX (journal) GO DBCC […]