ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,756 through 1,770 (of 10,143 total)

RE: Usage of CROSS APPLY

If you are using the output of an APPLY block as the input for another then you are likely to find a performance hit after x "levels of nesting". x...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 11, 2016 at 8:43 am

#1858052
RE: Comma separate list as parameter

SQLNightOwl (2/11/2016)
You may want to consider performance differences between using an IN and an INNER JOIN
select columns
from dbo.sometable
where ItemCode in (select Item from #tempTable)
-- AND --
select columns
from dbo.sometable st
inner
join...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 11, 2016 at 7:45 am

#1858033
RE: Improving Performance

Junglee_George (2/11/2016)
The hierarchy is there in the container data.
The result of #content shows the actual container level hierarchy in the container list starting with the top most level container.
If...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 11, 2016 at 4:39 am

#1857958
RE: Improving Performance

Junglee_George (2/11/2016)
I am using this particular query for an SSRS report
It has two multivalue parameters Partners and containers
When the user selects 45 partners and 42 corresponding containers, the performance issue...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 11, 2016 at 1:34 am

#1857931
RE: Improving Performance

Can you describe in words exactly what the code is supposed to do? It looks like you have a hierarchy in there - have you explored some of the more...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 10, 2016 at 8:16 am

#1857732
RE: I need help with a scalar function.

Orlando Colamatteo (2/10/2016)
ChrisM@Work (2/10/2016)
If it's only one, then the original scalar function returning the result to a variable would have been just fine - and it would have met Gail's...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 10, 2016 at 7:06 am

#1857707
RE: 4 Tables Join with comman column

syed_3177 (2/10/2016)
....Further details provided.
Thanks
Further details will need to be provided! Minimum requirements:
CREATE TABLE scripts for all tables.
INSERT scripts to populate those tables with a few rows of data.
A script to...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 10, 2016 at 5:21 am

#1857663
RE: I need help with a scalar function.

GilaMonster (2/10/2016)
ChrisM@Work (2/10/2016)
GilaMonster (2/10/2016)
ChrisM@Work (2/10/2016)
and it would have met Gail's precautionary restrictions too.
My comments had nothing to do with what the function returns, rather where to use it (not in...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 10, 2016 at 2:11 am

#1857615
RE: I need help with a scalar function.

GilaMonster (2/10/2016)
ChrisM@Work (2/10/2016)
and it would have met Gail's precautionary restrictions too.
My comments had nothing to do with what the function returns, rather where to use it (not in a DML...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 10, 2016 at 1:54 am

#1857611
RE: I need help with a scalar function.

Orlando Colamatteo (2/9/2016)
NineIron (2/9/2016)
k
Like this:
CREATE FUNCTION dbo.fnPressGaneyDownload()
RETURNS TABLE AS
RETURN (
SELECT CAST(
...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 10, 2016 at 1:45 am

#1857609
RE: Are the posted questions getting worse?

Eirikur Eiriksson (2/8/2016)
Sean Lange (2/8/2016)
Ack what a rough start to the week. My dog went for "last outs" about midnight last night and found a skunk. This is the second...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 9, 2016 at 1:43 am

#1857310
RE: Are the posted questions getting worse?

Sean Lange (2/8/2016)
Ack what a rough start to the week. My dog went for "last outs" about midnight last night and found a skunk. This is the second time in...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 9, 2016 at 1:42 am

#1857309
RE: How to get minimum date of an ID with respect to startdate?

Charmer (2/8/2016)
OMG,
I am sorry, Chris. The script is still wrong.
Just see the screen shot attached in here. The ID 4, having startdate '2016-01-27' should show '2016-01-26'
instead of '2016-01-27'. because we...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 8, 2016 at 6:40 am

#1857122
RE: How to get minimum date of an ID with respect to startdate?

Charmer (2/8/2016)
Let me explain the requirement.
I have to show the output with the changes happened to the point of startdate.
If ID 1 has a start date of today, I have...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 8, 2016 at 6:09 am

#1857110
RE: How to over come from outer apply

Hugo Kornelis (2/5/2016)
Yes, you are right. I had overlooked that. Both rewrites of the ORDER BY are incorrect, it needs to be kept as it was (with the ISNULL or...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 5, 2016 at 9:39 am

#1856919

Viewing 15 posts - 1,756 through 1,770 (of 10,143 total)