Click here to Skip to main content
15,904,339 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralHow to deal with that Kurmudgen Pin
MacSpudster10-Jan-14 11:37
professionalMacSpudster10-Jan-14 11:37 
GeneralRe: How to deal with that Kurmudgen Pin
Mike Hankey10-Jan-14 13:23
mveMike Hankey10-Jan-14 13:23 
GeneralMind...Blown Pin
IndifferentDisdain10-Jan-14 8:12
IndifferentDisdain10-Jan-14 8:12 
GeneralRe: Mind...Blown Pin
GuyThiebaut10-Jan-14 8:25
professionalGuyThiebaut10-Jan-14 8:25 
GeneralRe: Mind...Blown Pin
IndifferentDisdain10-Jan-14 8:27
IndifferentDisdain10-Jan-14 8:27 
GeneralRe: Mind...Blown Pin
GuyThiebaut10-Jan-14 8:38
professionalGuyThiebaut10-Jan-14 8:38 
GeneralRe: Mind...Blown Pin
Pualee10-Jan-14 8:35
Pualee10-Jan-14 8:35 
GeneralRe: Mind...Blown Pin
IndifferentDisdain10-Jan-14 8:52
IndifferentDisdain10-Jan-14 8:52 
It's not, and it's also joining another table (the table in question is the child, and it's being linked to the parent), but I've even tried eliminating different parameters, and that didn't make a difference.

However, removing the join, i.e. making the query as simple as possible, did result in a positive difference. So, that does lead me to think about the execution plan, but the data is nearly the same in our dev dbs as production, so that would seem strange that a different execution plan would be generated, though that may be the case.
GeneralRe: Mind...Blown Pin
GuyThiebaut10-Jan-14 23:17
professionalGuyThiebaut10-Jan-14 23:17 
JokeRe: Mind...Blown Pin
Richard Deeming10-Jan-14 8:35
mveRichard Deeming10-Jan-14 8:35 
GeneralRe: Mind...Blown Pin
IndifferentDisdain10-Jan-14 8:53
IndifferentDisdain10-Jan-14 8:53 
GeneralRe: Mind...Blown Pin
Ravi Bhavnani10-Jan-14 10:06
professionalRavi Bhavnani10-Jan-14 10:06 
GeneralRe: Mind...Blown Pin
IndifferentDisdain10-Jan-14 10:08
IndifferentDisdain10-Jan-14 10:08 
GeneralRe: Mind...Blown Pin
Ravi Bhavnani10-Jan-14 10:16
professionalRavi Bhavnani10-Jan-14 10:16 
AnswerRe: Mind...Blown Pin
IndifferentDisdain10-Jan-14 10:21
IndifferentDisdain10-Jan-14 10:21 
GeneralRe: Mind...Blown Pin
Ravi Bhavnani10-Jan-14 10:23
professionalRavi Bhavnani10-Jan-14 10:23 
GeneralRe: Mind...Blown Pin
_Maxxx_10-Jan-14 14:46
professional_Maxxx_10-Jan-14 14:46 
GeneralRe: Mind...Blown Pin
_Damian S_12-Jan-14 12:10
professional_Damian S_12-Jan-14 12:10 
GeneralWhile listening to The Who Pin
Ferd Really10-Jan-14 6:48
Ferd Really10-Jan-14 6:48 
GeneralRe: While listening to The Who Pin
DaveAuld10-Jan-14 7:19
professionalDaveAuld10-Jan-14 7:19 
General...The Eagles Pin
Ernst Iliov Stavro Blofeld10-Jan-14 8:18
Ernst Iliov Stavro Blofeld10-Jan-14 8:18 
GeneralRe: While listening to The Who Pin
OriginalGriff10-Jan-14 8:20
mveOriginalGriff10-Jan-14 8:20 
GeneralPink Floyd Pin
Mike Hankey10-Jan-14 8:23
mveMike Hankey10-Jan-14 8:23 
GeneralRe: While listening to The Who Pin
_Maxxx_10-Jan-14 14:48
professional_Maxxx_10-Jan-14 14:48 
GeneralLondon Underground map. Pin
Septimus Hedgehog10-Jan-14 5:12
Septimus Hedgehog10-Jan-14 5:12 

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.