Viewing 15 posts - 4,051 through 4,065 (of 10,144 total)
Junglee_George (9/3/2013)
How can I modify the query such that LEFT JOIN on activities, typeofactivities can be removed, so that query performance is good? This is my query:...
What do you want...
September 3, 2013 at 1:06 am
L' Eomot Inversé (8/30/2013)
September 2, 2013 at 1:36 am
jasona.work (8/30/2013)
Daniel Bowlin (8/30/2013)
sing4you (8/29/2013)
Jersey BoyThe Boss
Springsteen
Sprightly
August 30, 2013 at 7:41 am
Post your actual code too, please. With your pseudo code, it might provide enough information for folks to make a few guesses. If you're expecting good, solid, tested code, then...
August 30, 2013 at 6:31 am
Abu Dina (8/30/2013)
August 30, 2013 at 6:10 am
Without the TOP operator, the earlier actual plan shows 234,990 rows returned. With the TOP operator you're returning nearly a million rows ... can you confirm these figures are correct?
August 30, 2013 at 6:07 am
Also, change the datatype of d.MatchKey to that of a.MatchKeyType08.
August 30, 2013 at 5:39 am
Abu Dina (8/30/2013)
I've run my original code again to get the actual execution plan (attached below). Interestingly my original query ran in 15 seconds to produce 234990...
August 30, 2013 at 4:56 am
Without seeing the actual plan, I'd guess that the tvf is being applied to many more rows than it needs to be, i.e. before all of the available filters have...
August 30, 2013 at 4:13 am
Junglee_George (8/30/2013)
Thanks Gail. But Chris hasn’t written the code for the splitter function there. I need that code.
Sorry about that. It's in this article[/url].
I recommend you read the article, you...
August 30, 2013 at 3:59 am
Here's another way which you might find a little more intuitive:
;WITH
q1 (min_value, min_t_stamp) AS (
SELECT min(value), min(t_stamp)
FROM @t
WHERE value = (SELECT min(value) FROM @t)
),
q2 (min_value, min_t_stamp) AS (
SELECT...
August 30, 2013 at 3:45 am
Junglee_George (8/30/2013)
HiI achieved it through this way. The code below is working.
If any flaws are there in my approach, replies are welcome.
...
1. This expression
WHERE MC.isDeleted=0x0 AND charindex(MC.materialItemContainerCode,@containerCodes)<>0
isn't SARGable....
August 30, 2013 at 3:16 am
boriskey (12/16/2012)
Is there a way to pick a random value (like a color) from a...
August 29, 2013 at 4:35 am
Junglee_George (8/28/2013)
I need a help to modify my query to give comma-separated values as SP parameter. Any help is appreciated. Thanks in advance.
-- change your procedure
ALTER PROCEDURE [dbo].[eusp_e5_eSM_AS01_MaterialItemContainerlabelReport]
@containerCodes nvarchar(MAX)
AS
SELECT
MC.MaterialItemContainerCode,
MC.ReceptionDate,
C.clientName...
August 29, 2013 at 1:52 am
Viewing 15 posts - 4,051 through 4,065 (of 10,144 total)