Validated against: SQL Server 2005.
Updating statistics against each table in the current database by using the undocumented stored procedure [sp_MSforeachtable].
exec sp_MSforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN'
-
Recent Posts
- A SQL Read with NOLOCK, Causes a ALTER Table DDL statement to be Blocked or to Fail
- How to Get a SQL String Variable to be Larger Than 4000 Characters or 8000 Characters for Dynamic SQL
- Executing the same SQL statements against multiple servers and databases using SQL Server Management Studio, and Merging the Results
- SSIS Package Upgrade then error “Cannot use the OUTPUT option when passing a constant to a stored procedure”
- Blocked SQL Sessions and Blockers
Recent Comments
Tags
Categories
Blogroll
Links
Archives