RS First Dynamics NAV Blog


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

SQL Rebuild Indexing Effects

The above TSQL commands should run very fast (in one second) and may have the same effect as rebuilding the index if the slowdown is due to a problem with the query plan cache in SQL Server. use mastergo DBCC FREEPROCCACHEgo DBCC FREESYSTEMCACHE ('TokenAndPermUserStore') go  
Leggi tutto il post...
Categoria: Sql Server ALL
giovedì, 17 apr 2008 Ore. 09.39

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