Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tooba
Posting Yak Master
224 Posts |
 Posted - 2012-07-07 : 01:43:44
|
| Hi Guys, I need your help. I have a store procedure and its taking to long to execute that package. Our user are complainingabout to slow to retrieve that data. Please guide me which tips should i use for optimize this store procedure. I have 28 joins in this SP. Any help would be great. Thank You... |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-07-07 : 08:31:04
|
| If you google for how to optimize queries, you will find lot of resources that describe the best practices, what to look for etc. For example, this: http://msdn.microsoft.com/en-us/library/aa964133(v=sql.90).aspx. That article might look a little dense, but if you scroll down to the "Optimization Rules of Thumb" section, it has some very simple and useful guidelines. That is just one, there are tons of other resources.If you needs specific advice on your query, please post your query - there are experts on this forum who can take one look and suggest things that would improve the performance. They may ask for more information, but start by posting your query. |
 |
|
|
|
|
|
Store Procedure Optimization