Viewing 15 posts - 3,121 through 3,135 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 18, 2017 at 8:24 am
I realise that I've not posted the table definitions, but if anyone can give any insight here I'd really appreciate it: https://www.sqlservercentral.com/Forums/1897549/Execution-time-Improvement-Knowing-the-problem-but-not-the-solution
I'm pretty confident the problem...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 18, 2017 at 7:12 am
You need to likely use a CROSS APPLY or something similar. With no sample or expected data I've no idea what your data looks like, but here's an example of...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 18, 2017 at 5:10 am
If you are using the EXACT same SQL that is being run by the application (captured in profiler) under the same credentials, and SSMS is returning results and your application...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 18, 2017 at 4:42 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 18, 2017 at 4:24 am
This is a bit of a guess, based on your small dataset, but this, at least, might get the ball rolling:SELECT *,
CASE WHEN...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 18, 2017 at 3:42 am
This might seem a silly thing to say, but what have you done to check yourself? The best way to see which query performs better is to look at the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 18, 2017 at 3:13 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 18, 2017 at 2:41 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 18, 2017 at 1:50 am
What do you mean by the results are not the same? Could you be more specific? Provide sample outputs for one and the other and why they differ?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 15, 2017 at 12:59 pm
later i...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 15, 2017 at 9:43 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 15, 2017 at 9:24 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 15, 2017 at 9:06 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 15, 2017 at 8:43 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 15, 2017 at 8:31 am
Viewing 15 posts - 3,121 through 3,135 (of 5,109 total)