I've already uploaded it here as a zip file.

having a sqlplan won't give you the sql query (the one that matters) on this case as a view is being used.

main query is a view - I would bet...

• This reply was modified 5 years, 1 month ago by frederico_fonseca.
• This reply was modified 5 years, 1 month ago by frederico_fonseca.
• This reply was modified 5 years, 1 month ago by frederico_fonseca.

that is not an error but a info message - the last entry is an "error" but no description of what it is.

the other messages should be removed from the...

look at the examples supplied here - some do have error handling which you should have cared to use.

try adding firstrow option to start data at row 2 - row 1 is headers so it would blow the size of the columns you defined on that table.

            
August 5, 2020 at 11:32 pm
            
#3777679

            
            
                                                
        

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 5 years, 2 months 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 5 years, 2 months 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 5 years, 2 months ago by frederico_fonseca.