shiv-356842
SSCarpal Tunnel
Points: 4310
More actions
May 1, 2007 at 1:11 pm
#116963
Hi friends,
I am new in this MS SQL SERVER plz help me
Current my task is
Improve the performance of T-sql query, stored procedures only
What are the basic steps we have follow to imporve the performance
plz tell me some steps and tips.
Thanku
shiv
Gift Peddie
SSC Guru
Points: 73570
May 2, 2007 at 6:33 pm
#703975
Most of what you need is covered in the link below but a good place to start is click on show execution cost in Management Studio and run the code in Profiler. Hope this helps.
http://blogs.msdn.com/sqlqueryprocessing/archive/2006/09/26/771411.aspx
Kind regards,Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply