in Addition to the above (really hard to read forums now) it seems a tad bit slower loading the forums initial page.

why not the 2013 or even the 2016 version of the ACE driver?

2013 - https://www.microsoft.com/en-ie/download/details.aspx?id=39358

2016 - https://www.microsoft.com/en-ie/download/details.aspx?id=50040

You do not need to buy any special product in order to redistribute the...

If the server is Clustered then only TEMPDB can be on the local SSD

If it isn't then placing the DB on SSD could be an option.

And regular backups (every...

you need to change that bit of code to be dynamic sql - that way you can check for the existence of the column and only execute it if available

you do not need visual studio - it is advisable, but not a requirement.

SSDT will install on its own a Visual Studio Shell which contains all that is needed to...

One thing I would look at is splitting the call to the function dates into temp tables.

e.g. get distinct values of the dates that are being passed to the functions,...

change that foreach to a parallel.foreach is probably an option.

https://msdn.microsoft.com/en-us/library/dd460720(v=vs.110).aspx has a simple example.

and if required look for other examples on the net.

Thanks Steve. Indeed no pun intended with RTFM.

David, as per the link I added (from the manuals) there are indeed ways to do it - JDBC from what i could...

I did use it on a...

if excel file format is 2010 or higher then https://msdn.microsoft.com/en-us/library/office/gg575571(v=office.15).aspx may be an option.

this isn't a sql server question, but a Vertica question - RTFM is required.

Look at https://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/ConnectingToHPVertica/ClientJDBC/UsingVerticaCopyStream.htm as it may either help or guide you on the right direction

how does it improve if you backup onto 4 backup files, and explicitly enable compression on the backup command?

And how long does it take to backup using a single file?

and...

what is too slow?

And how are you doing the backup? single file? multiple files? with compression or without? and are files on same drive as database files or on a...

it also seems, altough i am be wrong, that you have indexes on that table.

For such high volume it is advisable to load to a table without any indexes and...

What I normally do on these cases is to have either a C# or a Powershell script that monitors the folder and once a new file arrives kicks off the...