Difference between revisions of "Template:SQWareProduction sqwmsq RebuildIndexDatabase.ksh presentation"
m (Updated by Expdbtools) |
m (Updated by BatchUser) |
||
| Line 1: | Line 1: | ||
<br>Generate reorganization commands for the database | <br>Generate reorganization commands for the database | ||
| − | <br>version = 2000 -> | + | <br>version = 2000 -> Dbcc dbreindex (N'[$lvsqw_Owner].[$lvsqw_TableName]','',90) |
| − | <br>version >= 2005 -> alter index all on [$lvsqw_Owner].[$lvsqw_TableName] | + | <br>version >= 2005 -> alter index all on [$lvsqw_Owner].[$lvsqw_TableName] Rebuild with (online = off) |
Revision as of 17:46, 5 April 2014
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)
