GilaMonster (7/7/2011)
Please note: 3 year old thread.Why would you recommend setting every single statistic in the database to not get automatically updated again? Very dangerous setting without some manual stats updates also recommended.
STRONGLY agree here. Suresh, can you please delete your post or edit it so that others don't see it in the future and think it is a good idea. It is a BAD idea to do norecompute.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service