How to improve MSSQL database speed for web application?

if you are at Logical Design in the SDLC you must normlize your database produce smaller and well structured relations.

and indexing it will be helpfull.

keep in your minde if you want your application to be faster you have to improve the way you are retrive the data from the data base its no related to the database its related to the way how do you code in database conection.