How to tune a query

http://www.c-sharpcorner.com/UploadFile/ff2f08/tips-to-improve-sql-database-performance/

http://csharp-video-tutorials.blogspot.com/2012/10/calling-stored-procedure-with-output.html

Hi,

To improve performance of SQL, we need to care many things.

Please refer my article

http://www.c-sharpcorner.com/UploadFile/ff2f08/tips-to-improve-sql-database-performance/

hope this will help you.

Here are the simple examples on how to write a store procedure and call it. Please have a look at them

Creating StoreProc

http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-part-18.html

http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-with-output.html

Calling StoreProc

http://csharp-video-tutorials.blogspot.com/2012/10/calling-stored-procedure-with-output.html

Wish it helps you.