ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,126 through 1,140 (of 10,143 total)

RE: Are the posted questions getting worse?

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...
^{“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

October 19, 2016 at 4:34 am

#1907365
RE: sql backup

Jeff Moden (10/18/2016)
Using compress backups and having a really good team that put together some remarkable hardware, I'm backing up 2.3 TeraBytes to Network Attached Storage (NAS) in 1 hour...
^{“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

October 19, 2016 at 2:07 am

#1907341
RE: Query Performance - MIN vs Top 1

Phil Parkin (10/18/2016)
ChrisM@Work (10/18/2016)
mitzyturbo (10/18/2016)
Sorry Chris, forgot to attach the indexes
Happy enough to go with the TOP 1 in a CROSS APPLY
Thanks anyway
Here's the ROW_NUMBER version. I think the index...
^{“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

October 18, 2016 at 10:19 am

#1907204
RE: Dynamic rows into columns

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...
^{“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

October 18, 2016 at 10:01 am

#1907195
RE: Query Performance - MIN vs Top 1

mitzyturbo (10/18/2016)
Sorry Chris, forgot to attach the indexes
Happy 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...
^{“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

October 18, 2016 at 9:53 am

#1907191
RE: Query Performance - MIN vs Top 1

mitzyturbo (10/18/2016)
Sorry Chris, forgot to attach the indexes
Happy enough to go with the TOP 1 in a CROSS APPLY
Thanks anyway
Sure no probs - but do try that index 😉
^{“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

October 18, 2016 at 9:44 am

#1907185
RE: Query Performance - MIN vs Top 1

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...
^{“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

October 18, 2016 at 9:21 am

#1907176
RE: Are the posted questions getting worse?

BLOB_EATER (10/18/2016)
Grant Fritchey (10/18/2016)
Wow, just read the comments on Reddit about a recent blog post... ouch.
Evidently stating the obvious when others are stating the opposite is not allowed amongst those...
^{“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

October 18, 2016 at 6:48 am

#1907122
RE: Dynamic rows into columns

seismicbeat (10/17/2016)
Hello,
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...
^{“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

October 18, 2016 at 5:48 am

#1907104
RE: Blocking by Insert

Rechana Rajan (10/17/2016)
ChrisM@Work (10/17/2016)
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...
^{“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

October 17, 2016 at 7:01 am

#1906845
RE: Blocking by Insert

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....
^{“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

October 17, 2016 at 5:58 am

#1906831
RE: Blocking by Insert

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...
^{“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

October 17, 2016 at 5:19 am

#1906826
RE: Are the posted questions getting worse?

Brandie Tarvin (10/13/2016)
GilaMonster (10/13/2016)
Grant Fritchey (10/13/2016)
Sean Lange (10/13/2016)
WOW...http://www.sql-datatools.com/2016/05/sql-queries-tuning-and-optimization.html
This is supposed to be a list of things to do to optimize queries. While some of these are valid most of them...
^{“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

October 13, 2016 at 9:32 am

#1906378
RE: Query Performance

-- 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...
^{“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

October 13, 2016 at 9:07 am

#1906366
RE: Query Performance

-- 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...
^{“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

October 13, 2016 at 5:24 am

#1906289

Viewing 15 posts - 1,126 through 1,140 (of 10,143 total)