Difference between revisions of "Template:SQWareProduction sqwmsq RebuildIndexDatabase.ksh presentation"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
| (One intermediate revision by the same user not shown) | |
(No difference)
| |
Latest revision as of 16:08, 23 February 2025
Rebuild indexes for all databases
version = 2000 -> Dbcc dbreindex (N'[$lvsqw_Owner].[$lvsqw_TableName]',,90)
version >= 2005 -> alter index all on [$lvsqw_Owner].[$lvsqw_TableName] Rebuild with (online = off)
