Difference between revisions of "Template:SQWareProduction sqwmsq RebuildIndexDatabase.ksh presentation"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
(Tag: Blanking)
Line 1: Line 1:
−
<br>Rebuild indexes for all databases
+
 
−
<br>version = 2000 -> Dbcc dbreindex (N'[$lvsqw_Owner].[$lvsqw_TableName]','',90)
 
−
<br>version >= 2005 -> alter index all on [$lvsqw_Owner].[$lvsqw_TableName] Rebuild with (online = off)
 

Revision as of 09:38, 24 December 2024

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