ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,081 through 1,095 (of 10,143 total)

RE: Are the posted questions getting worse?

Jeff Moden (12/7/2016)
This Saturday, 12/10, marks the anniversary of a very unhappy event for me. It's the day that Dwain Camps fell to cancer. Dwain was a...
^{“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

December 8, 2016 at 3:39 am

#1916702
RE: Are the posted questions getting worse?

rodjkidd (12/7/2016)
Eirikur,
I'm about a 20 minute walk to the High Holborn Caffe 1882. Let me know if you still want to meet up today?
Chris, are you about?
Rodders...
Oh poo. Sorry I...
^{“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

December 8, 2016 at 3:32 am

#1916701
RE: Increase speed of WHILE LOOP with INSERT

Talvin Singh (12/1/2016)
I cant do that. thats assuming the top 1000 get added. a sku dataset may have 20000 and i need to randomly select 2000, not 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

December 1, 2016 at 10:12 am

#1915499
RE: Increase speed of WHILE LOOP with INSERT

Talvin Singh (12/1/2016)
Hi,
i have the following code:
WHILE (SELECT COUNT(*) FROM tblSKUGrown) < 1000
BEGIN
INSERT INTO tblSKUGrown (SKU, OL)
(SELECT CONCAT(x.SKU,'_n'), x.OL FROM
(
SELECT
ROW_NUMBER() OVER (ORDER BY s.OL desc) AS Row,
s.SKU,
s.OL
FROM RAW_skus s
)x
WHERE...
^{“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

December 1, 2016 at 9:52 am

#1915483
RE: Are the posted questions getting worse?

TomThomson (11/30/2016)
ChrisM@Work (11/30/2016)
Eirikur chose his workplace well - in addition to the coffee, there's a very fine pub almost next door too. I'm in NYNY this weekend, would be awesome...
^{“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

December 1, 2016 at 1:43 am

#1915335
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (11/30/2016)
UAT testing on new forums has started. In addition, a large internal bug hunt from random RG people last week found a few usability, and...
^{“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

November 30, 2016 at 9:28 am

#1915213
RE: Coalesce and Case

dsmith402 (11/29/2016)
Ok, that certainly makes sense. But how would this expression be re-written in order for it to work?
Drop the COALESCE, it's redundant and confusing.
CASE
WHEN FSI.FID IN ('1800','1810') AND FSI.StepCompletion...
^{“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

November 30, 2016 at 2:41 am

#1915109
RE: Are the posted questions getting worse?

rodjkidd (11/29/2016)
Eirikur Eiriksson (11/29/2016)
rodjkidd (11/29/2016)
Eirikur Eiriksson (11/24/2016)
Gazareth (11/24/2016)
Eirikur Eiriksson (11/24/2016)
Gazareth (11/24/2016)
BWFC (11/24/2016)
ThomasRushton (11/24/2016)
BLOB EATER (11/24/2016)
GilaMonster (11/24/2016)
Brandie Tarvin (11/24/2016)
Much prefer chocolate or herbal tea (decaf).
The office kitchen also caters to stranger...
^{“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

November 30, 2016 at 2:33 am

#1915107
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (11/28/2016)
My daughter grinds beans each morning for her french press and froths milk. She usually makes enough to give me a cup 😉
I've not heard...
^{“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

November 29, 2016 at 1:48 am

#1914880
RE: Are the posted questions getting worse?

Luis Cazares (11/23/2016)
Steve Jones - SSC Editor (11/23/2016)
robert.sterbal 56890 (11/23/2016)
What is on your menu for Thanksgiving?
Can you share any recipes?
Our family will be having Thanksgiving at my wife's parents with...
^{“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

November 23, 2016 at 9:33 am

#1914268
RE: Are the posted questions getting worse?

Brandie Tarvin (11/23/2016)
Because I won't be online tomorrow (or probably Friday), Happy Turkey Day to all who celebrate. Or Tofurkey Day, whichever floats your boat.
Enjoy the holiday!
Or even this scary...
^{“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

November 23, 2016 at 5:05 am

#1914191
RE: Number of logical reads very different between 2 supposed identical environments

Beatrix Kiddo (11/23/2016)
I really enjoyed reading that, Hugo.
Absolutely likewise!
It's 85% of a cracking good article, and an important one also. Row goal queries can have astonishingly bad plans, at...
^{“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

November 23, 2016 at 2:00 am

#1914170
RE: Are the posted questions getting worse?

BWFC (11/18/2016)
I've not tried it yet but it's definitely on the agenda. The next thing on the curing list is a ham. Hopefully I've not left it too late...
^{“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

November 18, 2016 at 6:42 am

#1913407
RE: Are the posted questions getting worse?

BWFC (11/18/2016)
ChrisM@Work (11/18/2016)
Eirikur Eiriksson (11/18/2016)
BWFC (11/18/2016)
TomThomson (11/17/2016)
BWFC (11/16/2016)
Sean Lange (11/15/2016)
Ed Wagner (11/15/2016)
Y.B. (11/15/2016)
Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)
That being said I did...
^{“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

November 18, 2016 at 2:26 am

#1913351
RE: Are the posted questions getting worse?

Eirikur Eiriksson (11/18/2016)
BWFC (11/18/2016)
TomThomson (11/17/2016)
BWFC (11/16/2016)
Sean Lange (11/15/2016)
Ed Wagner (11/15/2016)
Y.B. (11/15/2016)
Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)
That being said I did recently try...
^{“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

November 18, 2016 at 2:03 am

#1913341

Viewing 15 posts - 1,081 through 1,095 (of 10,143 total)