David Jedziniak maintains this blog and posts helpful tips and tricks on SQL Server and Dynamics GP development.
The opinions expressed here are those of the author and do not represent the views, express or implied, of any past or present employer.
The information here is provided without warranty of fitness for any particular purpose.
Thursday, October 27, 2011
Script to turn on Auto Create Statistics
sp_helpdb TWO
GO
ALTER DATABASE TWO SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE TWO SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE TWO SET AUTO_UPDATE_STATISTICS_ASYNC ON
GO
No comments:
Post a Comment