my take on this is " if you need to ask if NOLOCK should/can be used on a particular case then you do not know about it's issues and therefore...

nolock should NOT be added anywhere.

you can read (from many others) this one https://www.sentryone.com/blog/aaronbertrand/bad-habits-nolock-everywhere

try it on your test environment and  you will know if your assumptions are correct.

snip

OLD Server: 16 vCPU, 24 GB RAM

NEW Server: 4 vCPU, 8 GB RAM

Argh!  That had not been my understanding.  I'm guessing that this is what TL meant that he...

• This reply was modified 6 years ago by frederico_fonseca.

the plan for a single part is most likely not going to be the same when executed for more parts (and more companies potentially).

just based on the plan supplied and...

depending on how many vcpu's you got (if only 2 vCpu use 2 files instead), but most times splitting the backup onto 4 files does help even if the files...

what did their tech support/sales people advise you?

and what have you read about it on their documentation? last I saw it was quite clear on what you are asking.

what you are missing is a server with capable spec to hold your volume of data.

if you wish to know your bare minimum memory required for your Tabular databases do...

• This reply was modified 6 years ago by frederico_fonseca.

still no plan

rename it to .txt

and please put the full original code so we can look at it.

and get rid of those "with (nolock)" and distinct when using a group by

• This reply was modified 6 years ago by frederico_fonseca.

Run this against your Instances

IF OBJECT_ID('tempdb.dbo.##enterprise_features') IS NOT NULL
  DROP TABLE ##enterprise_features
 
CREATE TABLE ##enterprise_features
  (
     dbname   ...

for other readers benefit it may be worthwhile posting the T-SQL version of the above code.

I'm sure many will have some difficulties with similar constructs

that is Oracle SQL - Pipeline or Parallel Table Function - see https://docs.oracle.com/cd/B19306_01/appdev.102/b14289/dcitblfns.htm

and if you crosspost to other forums at least have the courtesy of posting the link to the...

I would change it to have the following construct instead

insert into ....

select @Location
     , sum(case
        ...

you don't need to be a admin to get AD information out of. although your AD admins may have locked it down so normal users are unable to "read" AD...