RS First Dynamics NAV Blog


...from NAV 3.60 to NAV 2013
Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

SQL CLEAN AUTO STATS & CREATE NEW

Well, the "Auto. Create Stats" and also "Auto. Update Stats" could be a real pain; I recommend to disable it. THe sufficiently maintain the required statistics you could implement a SQL Agent Job (or TSQL task for the MP) doing this: use [MyNAVdb]goexec sp_updatestatsgo exec sp_createstats 'indexonly' To get rid of the already existing auto-stats, you could exec this script (part of the NAV/SQL Performance Toolbox) declare @id int, @name varchar(128), @statement nvarchar(1000)declare stat 
Leggi tutto il post...
Categoria: Sql Server ALL
mercoledì, 21 set 2011 Ore. 09.48

Scrivi un commento


Non è possibile inviare commenti a questo Blog

Commenti

Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003