Increase sql server speed

Question

i have a C sharp application can i increase speed of sql server database (for insertion and selection)

Vilas Gite · Answer

Hi Jaya As per Mr. John stated that you can increase performance by SQL Server tuning advisor. This is best way to speed up your database. Also you can use Database Maintenance Plan for increase performance. refer DB Maintenance Plan : http://www.c-sharpcorner.com/UploadFile/73ba73/8075/?ArticleID=c223bfb3-ad6f-45fd-917d-8b0ec2fae774 --------------------------------------------------------------------------------------------------- If this reply helps your post…then check  This is correct answer

Jiteendra Sampathirao · Answer

Hi Link Link2

John Penn · Answer

You should look at how the tables are indexed. I posted a video here a while back explaining how to run the SQL Server tuning advisor. It will analyze the workflow and determine the best way to index your tables to increase performance.