ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,276 through 1,290 (of 10,143 total)

RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (8/16/2016)
Brandie Tarvin (8/16/2016)
Has anyone here used GitHub?
If so, what did you think about it? Was it helpful? Was it annoying? Any caveats I should be...
^{“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

August 17, 2016 at 2:10 am

#1895854
RE: Query subtree costs justify parallelism, but it doesn't

Indianrock (8/8/2016)
I see two other similar plans in the cache with a high number of executions/uses and quick runtimes. This bad boy has only one use and slow runtime....
^{“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

August 17, 2016 at 1:53 am

#1895850
RE: Strange update behaviour

cmullen77 29296 (8/11/2016)
Well I had no idea that a trigger would fire even if nothing is inserted/updated...
I modified the trigger to verify that SOMETHING was inserted before proceeding...
^{“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

August 17, 2016 at 1:39 am

#1895847
RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice

The Dixie Flatline (8/16/2016)
Interesting discussion, but I am concerned about the casual dismissal of the number of logical reads. A consequence of more logical reads is that, 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

August 16, 2016 at 9:52 am

#1895706
RE: Are the posted questions getting worse?

Brandie Tarvin (8/16/2016)
Has anyone here used GitHub?
If so, what did you think about it? Was it helpful? Was it annoying? Any caveats I should be warned about?
We're apparently getting it...
^{“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

August 16, 2016 at 6:12 am

#1895609
RE: Stored procedures and Creating tables. (Problem).

ben.brugman (8/16/2016)
The question was:
So how would you load/parse/store the data were all unnecessary data is filtered out before it is inserted ?
Given are the CSV files.
No additional Meta data is...
^{“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

August 16, 2016 at 5:51 am

#1895604
RE: How can I get estimated query plan

yujinagata72 (8/16/2016)
Hi,
If I have an SQL statement, I would like to get the estimated query plan in XML file without SSMS or SQL profiler, is that possible? The scenario is...
^{“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

August 16, 2016 at 5:46 am

#1895602
RE: String or binary would be truncated error.

twin.devil (8/16/2016)
ChrisM@Work, +1.
But if you still interested to use your own code then you just need to convert the NVARCHAR(MAX) when assigning it to @SQL4. Here is the updated query:
--...
^{“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

August 16, 2016 at 5:32 am

#1895594
RE: String or binary would be truncated error.

What are the REPLACEs there for?
declare @modelid nvarchar(50)= '68eeb617967eb2e685692486239128ff'
DECLARE @SQL4 NVARCHAR(MAX)
,@DynamicList4 NVARCHAR(MAX) = '';
SELECT @DynamicList4 += ',['+powerunit_natlang+'] = MAX(CASE WHEN powerunit_natlang = '''+powerunit_natlang+''' THEN a.value_primary ELSE ''''...
^{“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

August 16, 2016 at 2:53 am

#1895576
RE: Low Cardinality estimate in Hash match operator

jesijesijesi (8/13/2016)
Hi Guys,
Sorry to post this in 2014 forum, I did that because the problem seems to be fixed in the new cardinality estimator.
I am trying to fix a performance...
^{“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

August 15, 2016 at 9:35 am

#1895475
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (8/15/2016)
ChrisM@Work (8/15/2016)
Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match...
^{“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

August 15, 2016 at 9:23 am

#1895471
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (8/15/2016)
ChrisM@Work (8/15/2016)
Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match...
^{“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

August 15, 2016 at 9:02 am

#1895462
RE: Are the posted questions getting worse?

ThomasRushton (8/15/2016)
ChrisM@Work (8/15/2016)
ThomasRushton (8/15/2016)
Grant Fritchey (8/15/2016)
Hey Threadizens!
Grant!
Damn. Now I want to watch some Cheers.
Gosh never mind the telly, where's the best curry around here?
It depends. (sorrynotsorry).
Where are 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

August 15, 2016 at 7:12 am

#1895444
RE: Are the posted questions getting worse?

ThomasRushton (8/15/2016)
Grant Fritchey (8/15/2016)
Hey Threadizens!
Grant!
Damn. Now I want to watch some Cheers.
Gosh never mind the telly, where's the best curry around here?
^{“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

August 15, 2016 at 6:44 am

#1895422
RE: Are the posted questions getting worse?

Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match estimates miles out”. The OP had...
^{“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

August 15, 2016 at 1:45 am

#1895375

Viewing 15 posts - 1,276 through 1,290 (of 10,143 total)