Click here to Skip to main content
14,384,533 members
   

Database

 
QuestionJob runs 3 times longer Pin
VK1920-Jul-18 8:12
memberVK1920-Jul-18 8:12 
AnswerRe: Job runs 3 times longer Pin
Victor Nijegorodov20-Jul-18 9:01
memberVictor Nijegorodov20-Jul-18 9:01 
AnswerRe: Job runs 3 times longer Pin
Eddy Vluggen28-Jul-18 1:16
mveEddy Vluggen28-Jul-18 1:16 
GeneralRe: Job runs 3 times longer Pin
jschell28-Jul-18 8:14
memberjschell28-Jul-18 8:14 
GeneralRe: Job runs 3 times longer Pin
Eddy Vluggen28-Jul-18 11:23
mveEddy Vluggen28-Jul-18 11:23 
GeneralRe: Job runs 3 times longer Pin
digimanus14-Aug-18 4:01
memberdigimanus14-Aug-18 4:01 
GeneralRe: Job runs 3 times longer Pin
Eddy Vluggen14-Aug-18 4:08
mveEddy Vluggen14-Aug-18 4:08 
AnswerRe: Job runs 3 times longer Pin
Mycroft Holmes28-Jul-18 15:14
memberMycroft Holmes28-Jul-18 15:14 
I have run across this in stored procedures, one of the more esoteric problems was "parameter sniffing", basically it comes down to moving your input parameter values to local variables.

Create proc ....
@InputID int
as
Declare LocalID int
Set @LocalID = @InputID


And use @LocalID int the body of the procedure
Never underestimate the power of human stupidity
RAH

Questionjoin query Pin
Member 1391987420-Jul-18 5:53
memberMember 1391987420-Jul-18 5:53 
GeneralRe: join query Pin
Richard MacCutchan20-Jul-18 6:13
protectorRichard MacCutchan20-Jul-18 6:13 
AnswerRe: join query Pin
Victor Nijegorodov20-Jul-18 8:59
memberVictor Nijegorodov20-Jul-18 8:59 
AnswerRe: join query Pin
Mycroft Holmes20-Jul-18 13:58
memberMycroft Holmes20-Jul-18 13:58 
QuestionProblem sending email to group Pin
Danpeking11-Jul-18 0:33
memberDanpeking11-Jul-18 0:33 
AnswerRe: Problem sending email to group Pin
jschell16-Jul-18 17:12
memberjschell16-Jul-18 17:12 
GeneralRe: Problem sending email to group Pin
Danpeking16-Jul-18 23:42
memberDanpeking16-Jul-18 23:42 
QuestionReport server moved from one server to another server Pin
VK1910-Jul-18 9:04
memberVK1910-Jul-18 9:04 
QuestionSSIS Best Practice Regarding Storage Pin
#realJSOP27-Jun-18 4:52
mve#realJSOP27-Jun-18 4:52 
AnswerRe: SSIS Best Practice Regarding Storage Pin
Jörgen Andersson2-Jul-18 22:16
protectorJörgen Andersson2-Jul-18 22:16 
AnswerRe: SSIS Best Practice Regarding Storage Pin
Eddy Vluggen3-Jul-18 0:19
mveEddy Vluggen3-Jul-18 0:19 
GeneralRe: SSIS Best Practice Regarding Storage Pin
#realJSOP3-Jul-18 4:08
mve#realJSOP3-Jul-18 4:08 
GeneralRe: SSIS Best Practice Regarding Storage Pin
Eddy Vluggen3-Jul-18 4:30
mveEddy Vluggen3-Jul-18 4:30 
GeneralRe: SSIS Best Practice Regarding Storage Pin
#realJSOP3-Jul-18 6:13
mve#realJSOP3-Jul-18 6:13 
GeneralRe: SSIS Best Practice Regarding Storage Pin
Eddy Vluggen3-Jul-18 6:30
mveEddy Vluggen3-Jul-18 6:30 
GeneralRe: SSIS Best Practice Regarding Storage Pin
#realJSOP3-Jul-18 6:43
mve#realJSOP3-Jul-18 6:43 
GeneralRe: SSIS Best Practice Regarding Storage Pin
Eddy Vluggen3-Jul-18 9:43
mveEddy Vluggen3-Jul-18 9:43 

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.