What I mean by sequential is to just don't do the same task simultaneously.  So if you are calling a stored procedure, just make sure your package only calls that...

I wouldn't bother with NOLOCK as that doesn't work with UPDATE queries.  Won't get a syntax error, the hint just gets ignored.

As for a good alternative, if you NEED a...

Jeff I think this may be a thing that we have to agree to disagree on.  I am not saying that SQL shouldn't be the first solution you look at...

The index ID and the Object_ID are tied together.  Object_ID will tie back to a table whereas the Index ID will tie back to an index ON the table.  So...

Stream design doesn't introduce blocking.  Your stored procedure is creating the blocking.

You even said it creates blocking - you are requesting an update lock on the table.  So anything that...

Index fragmentation is a very heated debate on SSC and ranges between "don't ever do it" to "do it once it gets above x%".  My advice - if the index...

it depends.  Having multiple "streams" call the same stored procedure that is updating a table will create blocking on that table and each one will need to wait for the...

My approach is to watch for long running queries.  If I have a long running query, then I probably need an index (or other tuning) of some sort.  I would...

Can you post some DDL?  We have no sample data to go off of and your query that you have there doesn't have an end to it or a FROM...

It depends.  The order for the index is the order it is "ordered" in the table.  So if you order it by col1 and col2, it is REALLY by col1...

Do you have any 3rd party plugins installed (ApexSQL, RedGate, etc)?

I had a weird conflict with ApexSQL Model + ApexSQL Refactor + RedGate SQL Prompt.  Had to remove the ApexSQL...

Something to note - if you don't have a visual studio subscription, I am pretty sure that SSRS is going to require a license to use, as will SQL Server. ...

Is there a reason you aren't installing SQL Server 2019 as the instance for SSRS 2019?

But as for compatability, I can't see why it wouldn't work.  What error are you...

My approach to this - what changed since this was working 100% of the time?  If this was always working until you installed CU21, then it is likely a bug...

I like option 3 of blank.  And the fact some people picked that.

But this is a good one to know if you don't have a Git GUI.