I was wondering what are some of the best practices to optimize nav with sql server. I tried searching on google and i cant really find a clear set of best practice. Our company is trying to fine tune the database for one of our clients. Also, we are looking for ways to increase (make efficient) the READ and WRITE capabilities of the system while reducing the size of the database.
Any tips or properties that we can setup in the system that might help achieve this goal will be greatly appreciated.
Also, if you know of any tools (paid/free) that might help with this optimization.