CREATE TABLE [dbo].[UserTrail](
[usrt_int_Id] [bigint] IDENTITY(1,1) NOT NULL,
[usrt_int_FacilityId] [bigint] NULL,
[usrt_int_EntityTypeId] [bigint] NOT NULL,
[usrt_int_EntityId] [bigint] NOT NULL,
[usrt_uid_TransactionId] [uniqueidentifier] NULL,
[usrt_vch_EntityDetails] [nvarchar](max) NULL,
[usrt_int_UserActionId] [bigint] NOT NULL,
[usrt_int_UserId] [bigint] NOT NULL,
[usrt_dtm_DateTime] [datetime] NOT...

Well damnit, yep ... there is a table there. I thought I checked this before. Found a single table, no data in it.

Using

ALTER TABLE dbo.blob SET (FILESTREAM_ON="NULL")

Results...

Thanks Brian Gale. I was going to reserve that as a follow up option. Would like to figure out how to turn it off on a replica of the database...

Ohhhh, I see what you're saying about the estimated row size on the CCI ... yeah, we don't manage those. I don't have a ton of experience with columnstore, how...

Thanks Brian!

Odd, thought I had the actual, attached here.

Yeah, the CCI has more than it needs; however, why would simply adding this index to Unicorns to remove the RID lookup,...

Thanks. When I look at the call from EF, it does show it has a taskpriority="0".

I thought the HIGHER number would be the victim, I have it reversed?

So setting the...

Hey Jeff, I remember your name ... way back when in my DBA days. Thanks for the response. My DBA skills are relatively rusty these days, went and got stuck...

• This reply was modified 4 years, 7 months ago by  Adam Bean.
• This reply was modified 4 years, 7 months ago by  Adam Bean.
• This reply was modified 4 years, 7 months ago by  Adam Bean.

So found something odd. It's the join on the date that is killing this. I converted to a where, tried a between, no change:

and dsst.TransactionDate >= ps.StartDate AND (dsst.TransactionDate <=...

disregard this follow up, had issues with file uploads

• This reply was modified 4 years, 7 months ago by  Adam Bean.

@frederico_fonseca - awesome find! Yeah, that absolutely worked, just as fast as using the RECOMPILE hint. Thank you!

I'm still not yet clear on why the original problem exists...

Attached, hopefully!

OK well, I guess we can't upload .sqlplan files eh?

I added an index hint option, execution plan shows it's using it ... but it still hangs! What the hell! (attached)

Soooo, I let the query run, it was up to 3.5 hours! I am beyond amazed here. I cancelled it, added a new index (estimated exec plan gave me an...

Exec plans are on my to do, I haven't had the time to let it actually finish (the full 40 minute).

If it helps ... the EndDate from the PlacementActivity, is...