ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,306 through 1,320 (of 10,143 total)

RE: Are the posted questions getting worse?

GilaMonster (8/10/2016)
First time in years that I'm flying somewhere just for a vacation, no conferences involved. Scotland, to save anyone from wondering.
Someone please keep an eye on the corruption forums,...
^{“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

August 10, 2016 at 10:06 am

#1894844
RE: Additional table in statement with OUTER APPLY

Phil Parkin (8/10/2016)
TheFault (8/10/2016)
I've created the below query to retrieve some information on agent jobs scheduled which works fine and returns 33 rows. I'm trying to pull the next_scheduled_run_date from...
^{“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

August 10, 2016 at 10:02 am

#1894841
RE: Table with multiple field ID's with different values

-- untested, no data available (see Drew's post)
SELECT
users.id,
users.first_name,
users.last_name,
businesses.`name` AS BusName,
businesstypes.`name` AS BusIndustry,
businessforms.`name` AS BusForm,
x.BusRevenue,
x.BusFT_Emp,
x.BusPT_Emp,
usertypes.`name` AS User_Status,
users.counselor_userid
FROM users
INNER JOIN meetings ON users.id = meetings.user_id
--LEFT JOIN measures ON users.id = measures.user_id
OUTER APPLY...
^{“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

August 10, 2016 at 9:46 am

#1894832
RE: Data Overload

As part of an existing or anticipated PCIDSS [/url]requirement, we're looking at removing aged data relating to payment cards. For our purposes, no card equates to little further value 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

August 10, 2016 at 6:50 am

#1894759
RE: Actual and Estimates That old conversation.

Talib123 (8/10/2016)
Thanks for taking the time all
Conversions or functions on columns; is the most likely with this piece of code.
This is what I thought but just needed to get 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

August 10, 2016 at 6:32 am

#1894752
RE: Are the posted questions getting worse?

TomThomson (8/9/2016)
Phil Parkin (8/9/2016)
This code was generated by a tool.
Does anyone else subconsciously say "You can say that again" whenever they read this comment in auto-generated code? 🙂
It's more appropriate...
^{“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

August 9, 2016 at 9:21 am

#1894564
RE: Actual and Estimates That old conversation.

Talib123 (8/9/2016)
Hi All,
Apart from out of date stats, what can throw these 2 completely out of Sync.
Thanks
Tal.
Can you post the actual execution plan you are studying?
^{“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

August 9, 2016 at 9:19 am

#1894561
RE: Actual and Estimates That old conversation.

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

August 9, 2016 at 9:18 am

#1894558
RE: Table of Dates in TSQL

Luis Cazares (8/9/2016)
Even if with this amount of rows it might make no difference, avoid using recursive CTEs to ~~count~~ generate rows...
...because they're way too expensive for such a simple...
^{“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

August 9, 2016 at 8:35 am

#1894535
RE: Are the posted questions getting worse?

Phil Parkin (8/9/2016)
This code was generated by a tool.
Does anyone else subconsciously say "You can say that again" whenever they read this comment in auto-generated code? 🙂
Thanks for sharing Phil,...
^{“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

August 9, 2016 at 6:32 am

#1894503
RE: Query subtree costs justify parallelism, but it doesn't

Indianrock (8/8/2016)
This appears to be one that runs in the middle of the night only. 226 seconds last night. Since we're in the process of adjusting cost...
^{“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

August 8, 2016 at 9:19 am

#1894376
RE: Improve reporting stored procedure execution time - tuning temporary tables?

radu.gheorghiu (8/8/2016)
Here's the code for the clustered indexes:
create clustered index cls_ix_stores_for_budgets on #StoresBudgets (storeID, ProgramID);
create clustered index cls_ix_tmp_report_final on #temp_report_data (store_ID, newSourceID);
The other columns in the SELECT and GROUP...
^{“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

August 8, 2016 at 8:24 am

#1894353
RE: Query subtree costs justify parallelism, but it doesn't

Indianrock (8/8/2016)
Attached the plan
How long does it take this whopper to execute?
^{“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

August 8, 2016 at 8:16 am

#1894349
RE: Improve reporting stored procedure execution time - tuning temporary tables?

radu.gheorghiu (8/8/2016)
I have tested adding the clustered index to the temporary tables and the overall time of running the stored procedure increased (unfortunately).
To be fair, the amount of time added...
^{“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

August 8, 2016 at 7:59 am

#1894341
RE: Query subtree costs justify parallelism, but it doesn't

Indianrock (8/8/2016)
I see now that it is doing a group by Having at the end.
FROM ACCOUNT_OWNERSHIP_DOC_SUMMARY AS AccountOwnershipDocSummary02 WHERE ((AccountOwnershipDocSummary02.ACCOUNT_MODIFIED_MANUFACTURER_ID IN (SELECT AccountOwnershipDocSummary02_ACCOUNT_MODIFIED_MANUFACTURER_ID0 FROM (SELECT AccountOwnershipDocSummary02.ACCOUNT_MODIFIED_MANUFACTURER_ID AS AccountOwnershipDocSummary02_ACCOUNT_MODIFIED_MANUFACTURER_ID0 FROM ACCOUNT_OWNERSHIP_DOC_SUMMARY...
^{“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

August 8, 2016 at 7:37 am

#1894333

Viewing 15 posts - 1,306 through 1,320 (of 10,143 total)