ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,741 through 1,755 (of 10,143 total)

RE: Five previous working days

hoseam (2/17/2016)
Hi
I'm struggling to write a code to get five previous working days. I'm trying to get 'Today', 'Yesterday', 'A day before Yesterday', '3 days prior Today' and '4 days...
^{“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 17, 2016 at 3:32 am

#1859208
RE: ROW_NUMBER() function with a difference

The dual-rownumber method is also promising:
DROP TABLE #Sample
CREATE TABLE #Sample (pkLocalPatientLocalID VARCHAR(2),pkSpellLocalID VARCHAR(3),WardLocation VARCHAR(20),WardSequence INT,RoomName VARCHAR(20),Bed INT,BedSequence INT,StartDateTime DATETIME,FinishDateTime DATETIME,[WardSequence Required] INT)
INSERT INTO #Sample
(pkLocalPatientLocalID,pkSpellLocalID,WardLocation, WardSequence,RoomName, Bed, BedSequence, StartDateTime, FinishDateTime,...
^{“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 16, 2016 at 10:09 am

#1859029
RE: Are the posted questions getting worse?

SQLRNNR (2/16/2016)
jasona.work (2/16/2016)
GilaMonster (2/16/2016)
Cthulhu for president! Why vote for the lesser evil?
I'm leaning towards the Palpatine / Vader ticket myself...
Or if they don't make it, Bill and Opus...
(I refuse 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 16, 2016 at 10:08 am

#1859028
RE: Are the posted questions getting worse?

Lynn Pettis (2/16/2016)
The real problem is that those that govern have forgotten who are the masters and who are the servants. Government is supposed to the servants of 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

February 16, 2016 at 9:02 am

#1859006
RE: Are the posted questions getting worse?

GilaMonster (2/16/2016)
Cthulhu for president! Why vote for the lesser evil?
Cthulhu's already president - of the "other" united states.
^{“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 16, 2016 at 7:59 am

#1858987
RE: Help with understanding how SQL behaves with inner joins

-- the DISTINCT appears to be redundant, there were the same number of rows either side of the distinct sort operator.
SELECT
o.sys_key, -- "o" is the alias for table...
^{“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 16, 2016 at 7:02 am

#1858969
RE: Help with understanding how SQL behaves with inner joins

nadersam (2/16/2016)
What i need to check is the index scan on Patient table.
This is a big table and accessed by most functions in system.
Is there anyway to reduce the count...
^{“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 16, 2016 at 5:56 am

#1858949
RE: purging old data and outer joins

Orlando Colamatteo (2/15/2016)
Can you try it in order from most rows to least, see Jeff's follow-up post to mine. The thought being to reduce the set as much as possible...
^{“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 16, 2016 at 4:42 am

#1858942
RE: Are the posted questions getting worse?

Jeff Moden (2/15/2016)
TomThomson (2/15/2016)
Jeff Moden (2/15/2016)
Sean Lange (2/15/2016)
Grant Fritchey (2/15/2016)
Hugo Kornelis (2/15/2016)
jasona.work (2/15/2016)
So, a question for everyone:
How do you feel if someone comes back and tells you that they tested...
^{“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 16, 2016 at 1:28 am

#1858915
RE: Are the posted questions getting worse?

jasona.work (2/15/2016)
So, a question for everyone:
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was...
^{“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 15, 2016 at 7:45 am

#1858785
RE: Help to optimize a SP

SQL!$@w$0ME (2/12/2016)
Thanks, Please see the actual plan attached.
1. Can you amend the index as suggested earlier?
2. Can you run it with sensible parameters such that it returns a result set?
^{“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 12, 2016 at 7:25 am

#1858341
RE: Help to optimize a SP

SQL!$@w$0ME (2/12/2016)
Tks. I've attached the sqlplan.
Add ActivityDescription as an INCLUDE column to index [IX_Activity_ActivityCodeId_DeletedAt_CaseId_ActivityDate], it's currently showing as 78% of the total cost of the query and masking everything 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

February 12, 2016 at 7:12 am

#1858335
RE: Help to optimize a SP

SQL!$@w$0ME (2/12/2016)
Tks. I've attached the sqlplan.
That's the estimated plan. Can you post the actual plan please?
^{“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 12, 2016 at 6:41 am

#1858327
RE: Help to optimize a SP

SQL!$@w$0ME (2/12/2016)
Could you guys please review the attached Stored Procedure and advise if optimization is needed.
-- Stored Procedure
CREATE procedure [dbo].[PeerReviewsGet]
as
begin
select Review_tab.ReviewId CustomerReferralId,
Review_tab.ActivityId ReviewActivityId,
ImeEventDetail.Id ImeEventDetailId,
activity.Id ActivityId,
caseinfo.casenum as CaseNumber,
convert(varchar, ImeEventDetail.ImeEventId) + ImeEventDetail.Extension...
^{“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 12, 2016 at 5:47 am

#1858300
RE: How to extract overlapping date ranges from a table of date ranges

Here's a live topic on the subject.
^{“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 9:11 am

#1858062

Viewing 15 posts - 1,741 through 1,755 (of 10,143 total)