I did use it...

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

yes.

All access to a sql server database instance is done through a provider (normally OLEDB) so it does not matter if database is on an instance with same name or...

you need to setup 2 instances

Instance 1

-sql server

-ssis

-ssrs

-ssas tabular

instance 2

-ssas dimensional

have a look at this document http://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/sql-server-on-vmware-best-practices-guide.pdf.

As said above if a physical host is going to be fully dedicated to a single SQL instance then its better to...

I...

what we do at my shop is as follows.

All databases on DEV/UAT/FIT are named as follows

XXX_YYY_999_databasename

where XXX is one of DEV/UAT/FIT

YYY is the developer code/name

999 is the project being worked...

use the ACE driver - 32 and 64bit available and will process all versions of Excel. freely available at microsoft https://www.microsoft.com/en-us/download/details.aspx?id=39358

first thing I would look at on a vm environment is to check if both vm host and the vm machines have their power settings to high performance.

check this http://oraclehunterz.blogspot.ie/2013/06/ora-02391-exceeded-simultaneous.html

if you are executing code and/or querying over a remote dblink that can also happen

-- check last post on http://www.orafaq.com/forum/t/96704/ for this last issue