It would also help if you have a file specification from whoever is sending this file.  They should be able to tell you what each field represents and the relationship...

I believe you need to restructure the report to produce the single page for a person - and include a parameter to identify that person.  Once you have that report...

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...