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, 3 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, 3 months 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...

depending on your version maybe this will work https://quickbooks.intuit.com/enterprise/customer-resource-center/odbc-drivers/

one that isn't that expensive is Devart https://www.devart.com/odbc/quickbooks/ordering.html

what is 25Cr records - please give the full number. e.g. 25 000 000 or 2 500 000 000.

if it is what I think then you better get another 400...

if the database itself isn't on the terabyte size level why not just create an empty db and migrate all objects to it EXCEPT that one? then simple backup and...

as a rule always allow for free space 2.5 times the space of your biggest index. - both on data and on log file

you need to redo it on 2008 BIDS.

2012 and higher its easier to "change" but 2008 to 2012 was a major change of SSIS Engine