Difference between revisions of "Template:SQWareProduction sqwmsq RebuildIndexDatabase.ksh presentation"
m (Updated by Expdbtools) |
(No difference)
|
Revision as of 01:13, 15 December 2010
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)