are you aware that interop requires Excel to be installed on the server?

Not only that is not supported by Microsoft but it also has licensing implications and costs that your...

This is another example of Microsoft versus ANSI/ISO. When we set up the DECIMAL and NUMERIC data types, we were thinking of COBOL style picture data and BCD data....

and I would rethink the way the query is built

with so many parameters it would probably be better to create a temp table, populate it from the parameters and then...

Possibly your datafiles not set correctly.

what does this show?

select 
    InstanceDefaultDataPath = serverproperty('InstanceDefaultDataPath'),
    InstanceDefaultLogPath = serverproperty('InstanceDefaultLogPath')

Agree with Lowell - for small shops having SSMS open may be OK - for larger ones not really feasible. my shop its 250 Prod and 300 non prod -...

off course you are getting 4 columns with name of ID - you are doing a Select * so all columns will show.

if you only wish to have a single...

no option to define it as far as I can see.

But while I would use DMAT to assess issues with migrating/upgrading a database, I would then use  dbatools to...

compatibility mode will stay as per original db - this is to allow companies to migrate to a new SQL Version but still keep their db's on the original "version".

By...

have a look at http://byobi.com/2015/12/3-methods-for-shredding-analysis-services-extended-events/ - one of the methods is a C# one that you can do in SSIS.

Not if using...

from my own experience if your cpu is at 80% during etl/processing then CPU is not even being used as well as it should/could - I would look elsewhere.

Some of...

8 core license - see http://download.microsoft.com/download/7/8/c/78cdf005-97c1-4129-926b-ce4a6fe92cf5/sql_server_2017_licensing_guide.pdf - page 16

Note that for Standard the only option is to license the individual VM - if it was Enterprise the whole physical server...

Steve -  someone calendar messed up - your post is dated "December 3, 2019 at 12:00 am"

file group definition does not matter for this.

How you defined the tables on the destination server (e.g. heap/clustered,  and with/without compression) as well as how you copied the data is...

it depends.

if it is a select with just a few joins and small amount of data then 3 mins is too much (assuming server is capable and not hugely constrained)

but...