Click here to Skip to main content
14,425,416 members
   

Database

 
AnswerRe: inner join results Pin
Richard Deeming26-Jul-18 2:50
communityengineerRichard Deeming26-Jul-18 2:50 
AnswerRe: inner join results Pin
Victor Nijegorodov26-Jul-18 2:54
MemberVictor Nijegorodov26-Jul-18 2:54 
QuestionCreation of documentation automatically when creating or updating a stored procedure Pin
indian14323-Jul-18 14:49
Memberindian14323-Jul-18 14:49 
AnswerRe: Creation of documentation automatically when creating or updating a stored procedure Pin
Victor Nijegorodov24-Jul-18 11:12
MemberVictor Nijegorodov24-Jul-18 11:12 
AnswerRe: Creation of documentation automatically when creating or updating a stored procedure Pin
jschell28-Jul-18 8:13
Memberjschell28-Jul-18 8:13 
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 
Simple guess; there's now more data in you database.

If you have a lot of functions in your query, then those will slow it down. If you do lot of character-manipulations, it will slow down. Convert time often, and it will slow down.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

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 
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
communityengineerRichard 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
mva#realJSOP27-Jun-18 4:52 
AnswerRe: SSIS Best Practice Regarding Storage Pin
Jörgen Andersson2-Jul-18 22:16
communityengineerJö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
mva#realJSOP3-Jul-18 4:08 

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.