General downloads
SQL Clustered Index Fix v2
- Author
- kriki
- Category
- General downloads
- Date
- 25/01/2008
- First release
- 18/05/2006
- Size
- 58,15 KB
- Downloads
-
2213
Detailed statistics
- Downloads today 0
- 30 day downloads 8
- Total downloads 2213
- Overall download rank #402 / 2082
- Today page views 0
- 30 days page views 0
- Total views 8887
- Rating
Detailed statistics- x 2 100,00%
- x 0 0%
- x 0 0%
- x 0 0%
- x 0 0%
- Popularity
- Downloaded 2 times in the last two weeks
With this little tool, you can fix the clustered index-problem on SQL directly from Navision. As an extra, you can also do some maintenance on the indexes of SQL. It is possible to change the following properties of the indexes in Navision: “Clustered”, ”Enabled”, ”MaintainSQLIndex”, ”MaintainSIFTIndex”. Remember that the fields Date, Time or Modified fields of the object will be changed!
To be used only on a SQL-database of versions 4.0SP1, 4.0SP2. (I don’t know about future versions…)
Version 2:
- Added column "No. of records"
- Added field on top to filter
