How to tune a query

Question

How to tune a query? what are the steps u hav to follw while writing a stored procedure

Praveen Dhatrika · Answer

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.

Upendra Pratap Shahi · Answer

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

Jignesh Trivedi · Answer

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.