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,...

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...

-- 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...

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...

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...

TomThomson (8/9/2016)

---

It's more appropriate...

Can you post the actual execution plan you are studying?

Data skew.

...because they're way too expensive for such a simple...

Thanks for sharing Phil,...

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...

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...

How long does it take this whopper to execute?

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...

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...