Click here to Skip to main content
15,917,176 members
Home / Discussions / Database
   

Database

 
GeneralRe: General Performance Question Pin
#realJSOP4-Jan-10 12:21
professional#realJSOP4-Jan-10 12:21 
GeneralRe: General Performance Question Pin
Eddy Vluggen4-Jan-10 13:22
professionalEddy Vluggen4-Jan-10 13:22 
GeneralRe: General Performance Question Pin
#realJSOP4-Jan-10 14:32
professional#realJSOP4-Jan-10 14:32 
AnswerRe: General Performance Question Pin
Mycroft Holmes4-Jan-10 13:13
professionalMycroft Holmes4-Jan-10 13:13 
AnswerRe: General Performance Question Pin
Mycroft Holmes4-Jan-10 19:01
professionalMycroft Holmes4-Jan-10 19:01 
GeneralRe: General Performance Question Pin
#realJSOP4-Jan-10 23:25
professional#realJSOP4-Jan-10 23:25 
GeneralRe: General Performance Question Pin
Mycroft Holmes5-Jan-10 0:12
professionalMycroft Holmes5-Jan-10 0:12 
AnswerRe: General Performance Question Pin
David Skelly5-Jan-10 2:10
David Skelly5-Jan-10 2:10 
I'm not entirely sure what sort of response you're looking for here. How bad would a stored proc have to be? Well, I guess that depends on what it does. If it's a simple select, then it would have to be pretty bad. If it's a massive stored proc that does a zillion different things and only gets run once a year then I guess that it might not be badly written, it might just be slow and time-consuming, and you'll either have to live with it or find a different approach (don't do it all in one stored proc, break it down into manageable chunks, something like that).

I don't know that anyone will really be able to give you much advice beyond what you've already got from the others, certainly not without knowing more detail about the stored proc.
GeneralRe: General Performance Question Pin
#realJSOP6-Jan-10 0:35
professional#realJSOP6-Jan-10 0:35 
GeneralRe: General Performance Question Pin
David Skelly6-Jan-10 2:24
David Skelly6-Jan-10 2:24 
AnswerRe: General Performance Question Pin
Tim Carmichael5-Jan-10 6:31
Tim Carmichael5-Jan-10 6:31 
GeneralRe: General Performance Question Pin
#realJSOP6-Jan-10 0:36
professional#realJSOP6-Jan-10 0:36 
QuestionUpdating Data on Other Server?? [modified] Pin
AmbiguousName4-Jan-10 7:05
AmbiguousName4-Jan-10 7:05 
AnswerRe: Updating Data on Other Server?? Pin
Stryder_14-Jan-10 9:47
Stryder_14-Jan-10 9:47 
GeneralRe: Updating Data on Other Server?? Pin
AmbiguousName5-Jan-10 3:47
AmbiguousName5-Jan-10 3:47 
AnswerRe: Updating Data on Other Server?? Pin
Mycroft Holmes4-Jan-10 13:17
professionalMycroft Holmes4-Jan-10 13:17 
GeneralRe: Updating Data on Other Server?? Pin
AmbiguousName5-Jan-10 3:54
AmbiguousName5-Jan-10 3:54 
GeneralRe: Updating Data on Other Server?? Pin
Mycroft Holmes5-Jan-10 11:05
professionalMycroft Holmes5-Jan-10 11:05 
GeneralRe: Updating Data on Other Server?? Pin
AmbiguousName5-Jan-10 13:47
AmbiguousName5-Jan-10 13:47 
Questionexported the first column of an excel file to a table Pin
deva23-Jan-10 23:05
deva23-Jan-10 23:05 
Questionloop problem Pin
Jassim Rahma3-Jan-10 21:02
Jassim Rahma3-Jan-10 21:02 
AnswerRe: loop problem Pin
Jassim Rahma3-Jan-10 22:30
Jassim Rahma3-Jan-10 22:30 
GeneralRe: loop problem Pin
Jassim Rahma3-Jan-10 22:39
Jassim Rahma3-Jan-10 22:39 
GeneralRe: loop problem Pin
Mycroft Holmes3-Jan-10 23:45
professionalMycroft Holmes3-Jan-10 23:45 
GeneralRe: loop problem Pin
Jassim Rahma4-Jan-10 2:01
Jassim Rahma4-Jan-10 2:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.