Notes to myself on SQL-Server 2016 optimal settings:

Named pipes with the only setting (No TCP/IP or Shared memory) on SQL Express 2016 on my local machine reduced the time to download 540,000 entries in about a 1/10th the time and took approximately 5 minutes

The issue I had before was that something on the network stack was getting bottlenecked most likely. don’t know where though

On my MS-access filed linked to SQL-server 2016 it shows success


  • None

Vincent Tang