SQL Server Performance Forum – Threads Archive

Stored procedure review comments invited

Message is deleted.

I haven’t tested the SP listed by you, but as an initial testing from Query analyzer see the QUERY EXECUTION PLAN and capture the trace using PROFILER while this SP is executing and submit trace to INDEX TUNING WIZARD for basic recommendations on INDEXes. HTH _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Please refrain from making duplicate posts. I am deleting the other post to avoid confusion. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

I would suggest that possibly this logic would be better handled in the business layer(.net). I would consider using the disconnected nature of the dataset and move processing out of the Database. at least until yukon comes out. It just seems that with all of the logic your trying to implement it might be easier done and more maintainable in a more robust proramming environment.

No offence, and I’d be keen to hear other forum user’s views, but to tune or review this kind of code is what I get paid for. By asking forum users to do this kind of work, it’s basically asking for work for free. Tom Pullen
DBA, Oxfam GB

I agree with thomas, but I think the fact that noone has offered any specific useful advice speaks volumes in itself! Looking at the stored procs, I expect it would take me at least a morning to set up a test environment for it. Then maybe another half-day to tune it, time not many people can spare for free. But if its any consolation, I wish you the best of luck <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />

rang123 – I’m sorry if you were offended, but I think Tom and Chappy do have a point. You could try to ask a more specific question and I’m sure everyone would try to help you <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Bambola.

]]>