Oh, I get...

thanks for replies - does clarify things a lot.

regarding the particular test

insert into newtable with (tablock) select * from old table where $partition.<partitionfunctionname>(<partitioncolumn>) = <partitionnumber>

where partitionnumber = one of the...

I didn't give more details just to allow others to try and...

How busy is that server?

for that spec the inserts into new table should not take 1 hour for a pitiful 12 million rows unless server is nearly maxed.

regarding table

- are...

But that doesn't have anything to do with how many drives you have or whether or not you mix MDFs with LDFs.  It only has to do with the...

Cloud is slightly different than on prem - while on prem normally IOPS  and max throughput are not limited on a per vm and/or disk type/size, on cloud that is...

answer is not always correct on this case.

for an azure sqldb its either how many vcores you allocated or how many dtu's depending on the model you chosen.

and how much ram and what are the disk types...

what is the spec of that database instance? that will have an impact on it regardless of how you do it

and were you creating the index online or offline? -...

if they have direct access to the databases there is no way for you to prevent them from extracting the data. (other than using a tool like CyberArk which can...

is that size on the...

they don't  want us to help. they want us to do the full code for them for free.

based on the sample data string_split() will not work as it lacks the...

• This reply was modified 3 years, 1 months ago by frederico_fonseca.

assuming you are using SSIDDB it does not allow kerberos delegation.

quote from https://learn.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog?view=sql-server-ver16

SSISDB doesn't support constrained delegation. In a double-hop environment, if the service account of the SQL server that...

I am pretty sure you have heard of the word "replace" - use it to replace those 3 chars with another single delimiter that is not used within the text.

and...

and unless all your tables are columnstore tables do the backups with native compression turned on - files will be significantly smaller leading to faster backups and less space required.

Restores...