MS SQL Tips & Tricks
How to reindex all tables in database
To reindex all tables in database You just need to execute script bellow:
EXEC [sp_MSforeachtable] @command1 =
"RAISERROR('DBCC DBREINDEX(''?'') ...',10,1)
WITH NOWAIT DBCC DBREINDEX('?')"
See also
Comments
Menu
- [List of topics]
- Outsourcing IT
- References
- Leave message
- Guest book
- Circulum Vitae
- Download CV (PDF format)
"If we don't change, we don't grow. If we don't grow, we aren't really living. "
You are 8976 reader
since 1st April 2009
Was this document helpful?
| Yes | 57.1% |
4 |
| No | 42.9% |
3 |
Your vote
|
Network: GoldenLine · LinkedIn · Tiger's WebSite · Okucia budowlane Developed by Jacek Szarapa |
|