Whenever we get timeout error, we need To Speed up the queries by running the following Queries in Database
1) First Way is
ALTER INDEX ALL ON Tablename REBUILD WITH (FILLFACTOR = 80)
UPDATE STATISTICS Tablename WITH FULLSCAN, NORECOMPUTE
EXEC SP_UPDATESTATS
2) Second Way is
DBCC DBREINDEX (Tablename, '', 90)
2 comments:
Very useful command Bikash. I really appreciate this.
Sajith Premachandran
Very nice blog and useful queries
from
Ghanshyam
Post a Comment