ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,516 through 1,530 (of 10,143 total)

RE: Are the posted questions getting worse?

Sean Lange (6/14/2016)
Luis Cazares (6/14/2016)
Sometimes I just want to post RTFA(rticle).
People are given answers with an article that explains the solution, but won't bother reading and keep posting saying...
^{“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

June 14, 2016 at 7:29 am

#1884893
RE: How can i create a view that matches Fig-1 to Fig-2

bjaricha (6/14/2016)
You guys are great, thanks very much for your assistance, its working, created the view and all is working.
Thanks very much have a great day
Thanks for the feedback!
^{“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

June 14, 2016 at 6:56 am

#1884876
RE: Strange Performance Issue

davidlester.home (6/14/2016)
I did eventually get this to work, though it makes little sense. It turns out that dropping all the indexes on the table was the answer. With indexes the...
^{“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

June 14, 2016 at 6:53 am

#1884875
RE: How can i create a view that matches Fig-1 to Fig-2

bjaricha (6/14/2016)
Fig - 1
VersionPeriodAmount
11356801.88
21352626.71
12352626.71
22348441.86
13348419.71
23344224.23
14344180.63
24339973.56
15339909.23
25335689.6
35339973.56
45339973.56
55335689.6
16335605.26
26331372.08
36335618.49
46335639.5
56335639.5
66335639.5
Fig - 2
VersionPeriodAmount
11356801.88
22348441.86
23344224.23
24339973.56
55335689.6
66335639.5
Need your help thanks
Except for Period 1, you're choosing the max version per period (which is easy, see below). Why is this? What are...
^{“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

June 14, 2016 at 5:45 am

#1884849
RE: Need help using a Table variable in a dynamic sql query

Qira (6/11/2016)
...
Please help. As a result, I know - How to use Table variable in a dynamic sql query
This batch looks horrendously overcomplicated for what it's doing. Why can't you...
^{“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

June 14, 2016 at 2:05 am

#1884828
RE: Temp DB filling on simple update statement?

Jeff Moden (6/13/2016)
patrickmcginnis59 10839 (6/13/2016)
Jeff Moden (5/25/2016)
krypto69 (5/25/2016)
Hi,
I have a pretty simple update statement:
UPDATE eligibility
SET primary_plan = 0
FROM temp_eligibility e
WHERE eligibility.eligibility_id = e.eligibility_id
This statement is updating around 7 million rows....
^{“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

June 14, 2016 at 1:28 am

#1884821
RE: Stored Procedure throws Violation of PRIMARY KEY constraint when called concurrently whit same parameters

Y.B. (6/13/2016)
That was a great article Gail! Thanks for sharing, It's one of those subtle things most probably learn the hard way.
So with that in mind here is update...
^{“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

June 13, 2016 at 9:19 am

#1884693
RE: Stored Procedure throws Violation of PRIMARY KEY constraint when called concurrently whit same parameters

Y.B. (6/13/2016)
Maybe something like this would be better suited...
IF EXISTS (SELECT 1 FROM SomeTable WHERE ID = @id)
UPDATE SomeTable SET SomeText = @SomeText
ELSE
INSERT INTO SomeTable VALUES (@ID, @SomeText)
EDIT: Although this...
^{“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

June 13, 2016 at 7:53 am

#1884654
RE: Creating #Table

The two queries use different filters on the IDENTITY_MAP table. The first query (database sem5) uses
d.Name like '%New Denmark%' in the FROM list and
d.Name like '%New Dmark%' 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

June 13, 2016 at 7:01 am

#1884630
RE: T-SQL find unique records

That's the ticket! Nice job.
^{“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

June 13, 2016 at 6:35 am

#1884618
RE: T-SQL find unique records

durga.palepu (6/13/2016)
Thanks for the quick response!!
However this solution is not serving the purpose.
meanwhile I have tried and my solution is as followed, the problem with solution is unique record(s) from...
^{“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

June 13, 2016 at 5:01 am

#1884603
RE: Are the posted questions getting worse?

GilaMonster (6/13/2016)
Anyone coming to InsideSQL tomorrow?
There are some amazing dev sessions and I really wanted to go, but it would have meant buying the time off, and being so close...
^{“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

June 13, 2016 at 4:28 am

#1884591
RE: T-SQL find unique records

Eddie Wuerch (6/11/2016)
If this is an interview, then 'the needful' means "admit you don't know".
It's a curious expression isn't it. Never used in US or UK English, it seems 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

June 13, 2016 at 3:46 am

#1884578
RE: Row number with Pivot

Nice one, Luis 😎
^{“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

June 10, 2016 at 9:28 am

#1884423
RE: Row number with Pivot

If you don't like the PIVOT operator, you could use a cross tab query instead:
SELECT TOP(50)
tf.formid,
tf.formdate,
x.*
FROM tbl_forms tf
CROSS APPLY (
SELECT
[field-0-1] = MAX(CASE WHEN tff.filtertype = 0 AND tff.id...
^{“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

June 10, 2016 at 5:58 am

#1884353

Viewing 15 posts - 1,516 through 1,530 (of 10,143 total)