Template:SQWareProduction sqwmsq RebuildIndexDatabase.ksh presentation

From Wiki_dbSQWare

Revision as of 17:12, 7 April 2024 by BatchUser (talk | contribs) (Updated by BatchUser)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

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)

Retrieved from "https://wiki.dbsqware.com/index.php?title=Template:SQWareProduction_sqwmsq_RebuildIndexDatabase.ksh_presentation&oldid=27127"