ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,666 through 1,680 (of 10,143 total)

RE: Query can be improved?

GonnaCatchIT (3/23/2016)
Hi Team,
My SP is timing out , timeout is set to 30 seconds. SP has below query to fetch the youngest id
SELECT TOP(1) ID
FROM Table1 TB1...
^{“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

March 24, 2016 at 3:56 am

#1867336
RE: Are the posted questions getting worse?

Alan.B (3/23/2016)
ChrisM@Work (3/23/2016)
How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never expected that.
The idea of...
^{“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

March 24, 2016 at 3:17 am

#1867334
RE: Are the posted questions getting worse?

Ed Wagner (3/23/2016)
ChrisM@Work (3/23/2016)
Eirikur Eiriksson (3/23/2016)
ChrisM@Work (3/23/2016)
How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never...
^{“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

March 24, 2016 at 2:38 am

#1867332
RE: Are the posted questions getting worse?

Eirikur Eiriksson (3/23/2016)
ChrisM@Work (3/23/2016)
How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never expected that.
The idea...
^{“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

March 23, 2016 at 10:48 am

#1867169
RE: Are the posted questions getting worse?

jasona.work (3/23/2016)
ChrisM@Work (3/23/2016)
How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never expected that.
The idea of...
^{“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

March 23, 2016 at 10:46 am

#1867168
RE: Are the posted questions getting worse?

How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never expected that.
The idea of presenting fills...
^{“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

March 23, 2016 at 10:23 am

#1867154
RE: Query Performance Issue with multiple unions and a view

chandan_jha18 (3/22/2016)
Lowell\Chris- As per Lowell's advice I created smaller procedures and attaching the new plan. however, as Jeff pointed out those hash and merge join fat pipes appearing again. Not...
^{“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

March 22, 2016 at 10:00 am

#1866851
RE: Finding best matched/covering time period/s against a time period search

SELECT *
FROM @Data
WHERE (DateStart = @DateStart AND DateEnd = @DateEnd)
OR (DateStart >= @DateStart AND DateEnd <= @DateEnd)
^{“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

March 22, 2016 at 8:59 am

#1866821
RE: Are the posted questions getting worse?

Phil Parkin (3/22/2016)
Koen Verbeeck (3/22/2016)
Grant Fritchey (3/22/2016)
Koen Verbeeck (3/22/2016)
Grant Fritchey (3/22/2016)
Koen Verbeeck (3/22/2016)
In case you're wondering, I'm fine. I didn't have to be in Brussels today, so I avoided all...
^{“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

March 22, 2016 at 7:56 am

#1866784
RE: Are the posted questions getting worse?

BL0B_EATER (3/22/2016)
ChrisM@Work (3/22/2016)
Brandie Tarvin (3/22/2016)
BL0B_EATER (3/22/2016)
Does anyone else have an issue during submitting an article when you paste in some TSQL into the SQL snippet block and save it then...
^{“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

March 22, 2016 at 5:52 am

#1866718
RE: Are the posted questions getting worse?

Brandie Tarvin (3/22/2016)
BL0B_EATER (3/22/2016)
Does anyone else have an issue during submitting an article when you paste in some TSQL into the SQL snippet block and save it then go back...
^{“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

March 22, 2016 at 4:21 am

#1866697
RE: Is Skynet Coming?

Gary Varga (3/22/2016)
Has anyone considered that advanced AI already exists and that it has considered it too dangerous to make us aware of its presence?
In case a "squishy" fingers 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

March 22, 2016 at 3:17 am

#1866687
RE: Join Tables that are NOT related

moeessack123 (3/22/2016)
Hi All
I was tasked with writing a report for my director
The report would be goods received vs goods sold for the month from a specific supplier
The problem i'm...
^{“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

March 22, 2016 at 3:15 am

#1866686
RE: Query slow just once a day

Luis Cazares (3/18/2016)
OK, this is driving me nuts. I have a query that runs slowly once a day (2 minutes) and then runs fast every time (2-3 seconds).
It's a report...
^{“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

March 22, 2016 at 2:44 am

#1866682
RE: Query Performance Issue with multiple unions and a view

chandan_jha18 (3/21/2016)
Thanks Lowell. The NULL and the Or clause are business rules so won't be able to find my way around that.
I will try breaking the master proc and test...
^{“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

March 21, 2016 at 8:26 am

#1866475

Viewing 15 posts - 1,666 through 1,680 (of 10,143 total)