Click here to Skip to main content
14,486,406 members
   

Database

 
QuestionNeed to drop a schema in which there are some objects exist Pin
indian1431-Aug-18 6:28
Memberindian1431-Aug-18 6:28 
AnswerRe: Need to drop a schema in which there are some objects exist Pin
Mycroft Holmes1-Aug-18 15:03
professionalMycroft Holmes1-Aug-18 15:03 
AnswerRe: Need to drop a schema in which there are some objects exist Pin
CHill602-Aug-18 2:26
mveCHill602-Aug-18 2:26 
QuestionRe: Need to drop a schema in which there are some objects exist Pin
CHill606-Aug-18 1:40
mveCHill606-Aug-18 1:40 
GeneralLegacy software: can't load MSJTER35.DLL Pin
Keith Sheppard227-Jul-18 23:26
MemberKeith Sheppard227-Jul-18 23:26 
GeneralRe: Legacy software: can't load MSJTER35.DLL Pin
Victor Nijegorodov27-Jul-18 23:45
MemberVictor Nijegorodov27-Jul-18 23:45 
GeneralRe: Legacy software: can't load MSJTER35.DLL Pin
Keith Sheppard22-Aug-18 1:23
MemberKeith Sheppard22-Aug-18 1:23 
Questioninner join results Pin
Member 1386716325-Jul-18 18:12
MemberMember 1386716325-Jul-18 18:12 
AnswerRe: inner join results Pin
Richard Deeming26-Jul-18 1:50
mveRichard Deeming26-Jul-18 1:50 
AnswerRe: inner join results Pin
Victor Nijegorodov26-Jul-18 1:54
MemberVictor Nijegorodov26-Jul-18 1:54 
QuestionCreation of documentation automatically when creating or updating a stored procedure Pin
indian14323-Jul-18 13:49
Memberindian14323-Jul-18 13:49 
AnswerRe: Creation of documentation automatically when creating or updating a stored procedure Pin
Victor Nijegorodov24-Jul-18 10:12
MemberVictor Nijegorodov24-Jul-18 10:12 
AnswerRe: Creation of documentation automatically when creating or updating a stored procedure Pin
jschell28-Jul-18 7:13
Memberjschell28-Jul-18 7:13 
QuestionJob runs 3 times longer Pin
VK1920-Jul-18 7:12
MemberVK1920-Jul-18 7:12 
AnswerRe: Job runs 3 times longer Pin
Victor Nijegorodov20-Jul-18 8:01
MemberVictor Nijegorodov20-Jul-18 8:01 
AnswerRe: Job runs 3 times longer Pin
Eddy Vluggen28-Jul-18 0:16
professionalEddy Vluggen28-Jul-18 0:16 
GeneralRe: Job runs 3 times longer Pin
jschell28-Jul-18 7:14
Memberjschell28-Jul-18 7:14 
GeneralRe: Job runs 3 times longer Pin
Eddy Vluggen28-Jul-18 10:23
professionalEddy Vluggen28-Jul-18 10:23 
GeneralRe: Job runs 3 times longer Pin
digimanus14-Aug-18 3:01
Memberdigimanus14-Aug-18 3:01 
GeneralRe: Job runs 3 times longer Pin
Eddy Vluggen14-Aug-18 3:08
professionalEddy Vluggen14-Aug-18 3:08 
AnswerRe: Job runs 3 times longer Pin
Mycroft Holmes28-Jul-18 14:14
professionalMycroft Holmes28-Jul-18 14: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 4:53
MemberMember 1391987420-Jul-18 4:53 
GeneralRe: join query Pin
Richard MacCutchan20-Jul-18 5:13
mveRichard MacCutchan20-Jul-18 5:13 
AnswerRe: join query Pin
Victor Nijegorodov20-Jul-18 7:59
MemberVictor Nijegorodov20-Jul-18 7:59 
AnswerRe: join query Pin
Mycroft Holmes20-Jul-18 12:58
professionalMycroft Holmes20-Jul-18 12:58 

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.