Viewing 15 posts - 1,126 through 1,140 (of 10,143 total)
BLOB_EATER (10/19/2016)
Brandie Tarvin (10/19/2016)
ThomasRushton (10/19/2016)
rodjkidd (10/19/2016)
ThomasRushton (10/19/2016)
In other news, today I overheard m'colleague saying "maybe the DBA team would be a beacon..."at which point I lost the plot.
are you sure...
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
October 19, 2016 at 4:34 am
Jeff Moden (10/18/2016)
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
October 19, 2016 at 2:07 am
Phil Parkin (10/18/2016)
ChrisM@Work (10/18/2016)
mitzyturbo (10/18/2016)
Sorry Chris, forgot to attach the indexesHappy enough to go with the TOP 1 in a CROSS APPLY
Thanks anyway
Here's the ROW_NUMBER version. I think the index...
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
October 18, 2016 at 10:19 am
seismicbeat (10/18/2016)
@DesNorton, @chrism-2@Work, I really appreciate to all your help. 🙂 Thank you so much for leading me to the right direction.
You're welcome, thanks for the feedback. If you get...
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
October 18, 2016 at 10:01 am
mitzyturbo (10/18/2016)
Sorry Chris, forgot to attach the indexesHappy enough to go with the TOP 1 in a CROSS APPLY
Thanks anyway
Here's the ROW_NUMBER version. I think the index I posted earlier...
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
October 18, 2016 at 9:53 am
mitzyturbo (10/18/2016)
Sorry Chris, forgot to attach the indexesHappy enough to go with the TOP 1 in a CROSS APPLY
Thanks anyway
Sure no probs - but do try that index 😉
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
October 18, 2016 at 9:44 am
I can't see your indexes, can you confirm that this is one of them? If not, create it and test with both queries.
(entity, LogTxt, entityRowID) INCLUDE (LogDate, userName)
There's...
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
October 18, 2016 at 9:21 am
BLOB_EATER (10/18/2016)
Grant Fritchey (10/18/2016)
Evidently stating the obvious when others are stating the opposite is not allowed amongst those...
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
October 18, 2016 at 6:48 am
seismicbeat (10/17/2016)
I'm a SQL Server novice. I've been polishing up on my T-SQL skills while working for the last few months and I was tasked to come up with a...
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
October 18, 2016 at 5:48 am
Rechana Rajan (10/17/2016)
ChrisM@Work (10/17/2016)
Firstly, as Jeff pointed out, the SELECT. Use the OUTPUT...
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
October 17, 2016 at 7:01 am
No problem Rechana. Whilst Googling for [Forced Index = True] I came across this wonderfully succinct article by Grant Fritchey[/url]. A great starting point for reading and interpreting execution plans....
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
October 17, 2016 at 5:58 am
There are at least two issues here which will unnecessarily prolong an INSERT transaction using this process.
Firstly, as Jeff pointed out, the SELECT. Use the OUTPUT clause instead, like...
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
October 17, 2016 at 5:19 am
Brandie Tarvin (10/13/2016)
GilaMonster (10/13/2016)
Grant Fritchey (10/13/2016)
Sean Lange (10/13/2016)
This is supposed to be a list of things to do to optimize queries. While some of these are valid most of them...
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
October 13, 2016 at 9:32 am
-- Most of the cost of the query is reading the
-- portfolio table - with the aggregate performed AFTER this expensive bunch of seeks.
-- This version of the query might...
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
October 13, 2016 at 9:07 am
-- Your query matches portfolio.clientID to deadline.clientID
-- where does #Temp1.clientID fit into this?
-- It might be possible to do something like this
UPDATE a
SET Ret = x.Ret
FROM #Temp1 a
CROSS...
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
October 13, 2016 at 5:24 am
Viewing 15 posts - 1,126 through 1,140 (of 10,143 total)