ChrisM@Work

Forum Replies Created

Viewing 15 posts - 841 through 855 (of 10,143 total)

RE: performance information for sql server and databases

Grant Fritchey - Thursday, March 23, 2017 11:26 AM
Nuts. Sorry Chris. I didn't realize that wasn't the OP reporting a different problem....
^{“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, 2017 at 2:21 am

#1934700
RE: update table column with value from another table

wmbc - Thursday, March 23, 2017 10:37 AM
hello, I need some help trying to figure this one out.
TableA
id
tablebid
TableB
id
TableA has...
^{“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, 2017 at 10:59 am

#1934573
RE: performance information for sql server and databases

dangelo211 - Wednesday, March 22, 2017 12:30 PM
I need assistance in a SQL that has a performance issue . The query is...
^{“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, 2017 at 10:37 am

#1934564
RE: insert query takes too long ....

savibp3 - Thursday, March 23, 2017 10:05 AM
ChrisM@Work - Thursday, March 23, 2017 9:52 AM
^{“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, 2017 at 10:10 am

#1934556
RE: insert query takes too long ....

Sybase??
^{“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, 2017 at 9:52 am

#1934550
RE: Code not working in 2008/2005

andrew 67979 - Thursday, March 23, 2017 6:33 AM
The following code works fine in SQL 2014/2016 but gives me zero's in 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 23, 2017 at 8:28 am

#1934528
RE: insert query takes too long ....

savibp3 - Thursday, March 23, 2017 6:41 AM
I have a insert query in stored procedure it takes min 59 or 110 specs...
^{“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, 2017 at 8:17 am

#1934519
RE: Performance Tuning

You could use ROW_NUMBER or you could use APPLY, like this:
SELECT od
^{“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, 2017 at 7:40 am

#1934510
RE: Extracting Number from Text

-- I'd use a function for this, to mask the complexityfrom your queries:
^{“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, 2017 at 7:18 am

#1934504
RE: Performance Tuning

Thanks Bhavesh.
If I were given this query to tune, including access to a test database, then I'd break it down into manageable chunks and tune each chunk separately. Here'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

March 23, 2017 at 4:46 am

#1934472
RE: Differences in this where statement

elzool - Wednesday, March 22, 2017 12:05 PM
Chris Harshman - Wednesday, March 22, 2017 11:57 AM
^{“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, 2017 at 3:02 am

#1934455
RE: Performance Tuning

Essentally the same subquery appears twice in the part of the query which is attached to the plan. Rather than read...
^{“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, 2017 at 11:04 am

#1934334
RE: Join two tables that do not have matching keys

Neil Burton - Wednesday, March 22, 2017 8:33 AM
I see. It's logical that a function on the right of an ON (which...
^{“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, 2017 at 9:02 am

#1934317
RE: Join two tables that do not have matching keys

CREATE INDEX ix_Stuff
^{“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, 2017 at 7:59 am

#1934297
RE: Join two tables that do not have matching keys

Neil Burton - Wednesday, March 22, 2017 6:53 AM
ChrisM@Work - Wednesday, March 22, 2017 6:25 AM
^{“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, 2017 at 7:49 am

#1934294

Viewing 15 posts - 841 through 855 (of 10,143 total)