Template:SQWareProduction sqwmsq RebuildIndexDatabase.ksh presentation

From Wiki_dbSQWare
Revision as of 00:13, 15 December 2010 by Exploit (talk | contribs) (Updated by Expdbtools)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


Generate reorganization commands for the database
version = 2000 -> dbcc dbreindex (N'[$lvsqw_Owner].[$lvsqw_TableName]',,90)
version >= 2005 -> alter index all on [$lvsqw_Owner].[$lvsqw_TableName] rebuild with (online = off)