I don't think the difference in the systems is the determining factor in how fast this runs - it appears to me to be network related.  As shown above, running...

thanks Jeff.

so a bit slower on my pc - I7 4 core , 16GB ram, SSD drive - 29 seconds for same criteria.

on this type of multiple files output,...

Open Windows Powershell ISE - this is the development tool for Powershell included with Windows 10.

You will need to include 2 variables that I excluded from the post.  Those are:

$SQLServer...

I ran a test against your JBMTest table - here is the code that was executed and the Get-Date output.

Get-Date;

$yearFrom = "2019-01-01";
$yearTo = "2020-01-01";

1..53 | foreach {
...

Crap... I'm sorry Jeffrey.  I hit "report" instead of "quote" on your post by mistake.

As for the partitioning, please don't put words in my mouth.  The original decision to...

You can do this in Powershell:

$weeks = @(); 1..53 | ForEach {$weeks += $_};

Another method would be:

$yearfrom = "2020-01-01"
$yearto = "2020-01-01"
$exportfile = "c:\temp\datafile_--week--.csv"

1..53 |...

'data access patterns and table structure' is meant to include inserts/deletes/updates/selects - all methods of accessing and using that table.  And your answer is the same answer I have been...

Is there a particular issue you are trying to resolve?  Are you seeing performance issues related to the above questions - or is there another reason you are looking for...

And, no... my 4 year long experiment also shows that you can't just not do any index maintenance although not doing any index maintenance (still rebuilding stats, though) is...

I found that the easiest way to change the owner of a database in an AG - is the following:

1. Restore the database to the secondary with RECOVERY (before adding...

No - included...

I get all that - but changing over to 7-zip is going to require modifying the Execute Process Task to call a different executable with different command line parameters.

Here is...

Is there a reason why you cannot use the built-in .NET code?

In a script task, you can include the namespace System.IO.Compression and add a reference to System.IO.Compression.FileSystem - then use...

No - you would not need any additional servers and there wouldn't be any additional AG's.

• Node 1 is a single server - shared storage - SQL Server installed in...

I don't understand...if you have the following:

• Node1 - Primary
• Node2 - HA Secondary (AG) - synchronous
• Node3 - DR Secondary (AG) - asynchronous
• Node4 - Read-Only Secondary (AG) -...