This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Any recommended changes to SQL (advanced options or indexes)?

Has anyone found any improvements to their SQL environment that they recommend? Things like adding indexes, changing degree of parallelism, etc? There are lots of options to tune SQL performance for an application, so I figured I'd ask.