unless the client is able to do their own sql, the list of possible columns, or even formulas used, would be available upfront on the UI - so allowing them...

two comments

1 - your script is using Excel - this will not be supported on a Server and will have licensing implications to your company - are you aware of...

I partially disagree - splitting the backup into 4 or 8 files, and changing restore BUFFERCOUNT and MAXTRANSFERSIZE do affect restore performance.

but one thing that hugely affects restore is the...

• This reply was modified 2 years, 4 months ago by frederico_fonseca. Reason: change blocksize mention to the correct parameters on restore
• This reply was modified 2 years, 4 months ago by frederico_fonseca.

better to send email by PM and remove from post - easy pick for scammers

being a VM it is the same as having it on prem from an AD configuration point of view - unless someone decided to create a new domain for that...

Looks ok

things to consider if table is big (100's of GB) - ETL data based on partitions and once some source partitions are fully copied to new table truncate the...

if the range dates of the partitions (old and new tables) are not a match a switch is not possible.

if the partition column is the same date and the intention...

• This reply was modified 2 years, 4 months ago by frederico_fonseca.

in my shop we are now looking into it - but zero installs (other than 1 for DBA to test) for now.

and being delayed as MS patching on OS (from...

replace the double quotes with single quotes

as that is a partitioned table you need to allocate the desired partition to the destination filegroup

see https://learn.microsoft.com/en-us/sql/t-sql/statements/create-partition-scheme-transact-sql?view=sql-server-ver16

you either split them into rows in a table or you use dynamic sql . both of these assume you care with good performance.

not looking at performance there is a...

it could be the "LEGACY_CARDINALITY_ESTIMATION " being set to ON.

see https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-scoped-configuration-transact-sql?view=sql-server-ver16

IF the split means that you can "reduce" the number of rows in one of the tables due to "duplicate information" then you should do it if savings are significant...

while that may have been the case in older versions, actual versions DO ALLOW it for sure.

I would really ignore that - it is one of those vulnerabilities that require a USER to open a supplied third party file (specially crafted to abuse the vulnerability) on...