I hope the content though is still applicaple as on date [:D]
If your fragmentation is too high then definately the defrag would help you. You can check the fragmentation level using the DMVs. Generally it says...
I think part of it you can decode like your data, page no which was modified , record size . I will just show a small thing here -- create a...
Separate names with a comma.
