Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

performance & Tuning Stored procedures

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
I am new to SQL!
and I have two stored procedures about 1000 lines each, and it is grabbing information from almost 22 Tables. When I execute it taking too much time and I want to know is there any way that I can Improve the execution in less time. And I am using 6.5 version. In my stored procedure I am using cursors and Temp Tables.

Thanks
REDDY
 
Sort by date Sort by votes
Are those cursors nested? If so, remove as many nesting levels as possible using joins. The SQL Server is much better at dealing with sets than cursors.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
1K
pjw001
pjw001
ahmedsa2018
  • Locked
  • Question
Are this query below have problem on performance issue ?
Replies
1
Views
250
ahmedsa2018
ahmedsa2018
ahmedsa2018
  • Locked
  • Question
how to enhance this query for good performance ?
Replies
2
Views
227
johnherman
johnherman
BTrees
  • Locked
  • Question
How to increase performance of ROW_NUMBER() OVER (PARTITION BY..) in Sql Server 2016
Replies
4
Views
558
BTrees
BTrees
BeatriceC
  • Locked
  • Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
299
pjw001
pjw001

Part and Inventory Search

Sponsor

Back
Top