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.

Heh, I wouldn't say I am "smarter", I would say "I got lucky".  I took mrsiro's approach and just expanded on it.  A bad (or possibly good?) habit of mine...

I half agree with Jeff there.  Python may not be the best option for all use cases but, like cursors, there are cases where it is the best or only...

My opinion - I don't think there are that many use cases for using it.  Similar to R - you can access it externally, does it need to be baked...

Possibly not the most efficient approach, but I think this should work:

SELECT
[job3].[TheDate]
, REPLACE( [job3].[Security]
 , 'REMOVE:'
 , ''
 ) AS [Security]
, REPLACE( [job3].[Driver]
 , 'REMOVE:'
 , ''
...

Are you updating the tables sequentially or are some being done at the same time?

That being said, how many rows are being updated in tbl_people?  If on 2020-08-07 it updated...

• This reply was modified 5 years, 5 months ago by Mr. Brian Gale.

My opinion - I would use it when I need to do analytics on the data; similar to when you'd use R.

My approach though is to use these tools outside...

Alternately to Sue's approach, try matching your SSMS version to your SQL Server engine version.  I know some things behave strangely when you have mismatched versions.

It could be the disks.  It could be the data.  It could be the CPU or memory.  It could be blocking.  It could be none of those.  It could be...