Or any site available that covers all the topics in sql server?
The correct configuration and tuning of the server is very considerable, otherwise even expensive server hardware won’t perform well. By using indexes on database tables, you can greatly enhance the operation of your server. The SQL server has a tool known as the Index Tuning wizard for this purpose. After identifying the buzz whose performance you want to optimize, you can start the index tuning from using the Enterprise manager. This will tell you how much amendment there would be once the changes have be made. You can find more on Indexes and server tuning.