Still got this in SQL 2022.

Despite clearing log history right down the "Initialize Log" number initially climbs to 235, to then only return a handful of records.

No idea where all...

Thank you, it's very frustrating isn't it!

The users have PBI desktop and we deploy to PBI on premise.

The spreadsheet sits in teams.

Thank you all, 
That's given me some more ideas to try.

Ah, I thought I'd avoided Sargability by not manipulating my date column, only the GETDATE() function.
Thanks for that,
Rich

My AD groups are too large to use Get-ADGroupMember.
Going to attempt it using the Members property of Get-ADGroup and iterate that results set.

Anyone attempted this?  Or got a better...

i've used sp_whoisactive to get the query plan.
it does show a table spool costed at 36% to support an Index Insert so that must be my culprit.

Yes, it makes a difference for a short while, but then the problem reoccurs.

Sorry, I forgot to put that in my original post :/

Now that Management Studio is being updated...

vivasjimmy - I've encountered this in the past.

Look at permissions and get your task to be owned and executed by an account with the appropriate permissions.

You may have to add...

It's a great technique. I've been doing similar for years.

I've recently recreated it in PowerShell, but keep having to revert to batch files as clients don't have up to date...

thank you.why did i not think of that!

doh!

Cheers Ed, that's great. I guess it works better due to the function not exposing statistics to the query optimiser, but welcome you're take on what inspired you to change...

The article has served to remind me to re-read the original.

I do hope Omeswar is not going to get paid for his Copy and Paste technique.

Oops, the application being on the same server as SQL means you'll probably have to pay attention to memory settings to make sure they don't fight over memory.

Replicating to a...

Hi Horatio,

Your post raises quite a few issues. Here is my take on them...

Shrinking the database - DON'T

When new data is inserted it will auto-grow and your data files will...