 |
 |
Always defrag your hard disk before defragmenting your SQL Server indexes for the best results and faster performance. |
|
|
Update statistics and then recompile stored procedures after you defrag to speed up SQL queries even more. |
|
|
Defragmentation is a resource intensive activity. Schedule defrag jobs out of core business hours so users aren't affected. |
|
|
Keep index fragmentation at or below 40% to keep performance issues at bay. |
|
|
Visual Defrag can be installed on the client or server, but we recommend you install and use it on your client. |
|
| Now You Know How to Speed Up SQL Server, Get Your Free Download! |
|