Merry Christmas everyone, hope you enjoy the holiday(s). Day early, but I doubt that anyone'll be about tomorrow anyway :D.

Happy to review as well. Probably better at T-SQL related articles, such as functions, "best practices", etc, but also happy to look at things based on SQL Server on Linux....

Can you provide some sample data and expected results please (see the link in my signature on how to do this). Your description is rather vague at best, and with...

I suspect one of the reasons your query is "slower", is because in your first batch you are checking for the existance, and dropping and creating the table tblTest in...

In your first query, the literal values 2 varchar(4)'s and an int, therefore, they are implicitly cast to a varchar(50) and bigint respectively when inserted. The datatypes are declared...

I assume you're logged in as that domain user? If you are a sysadmin, however, you'll already have the permission, so you have no need to grant it to yourself.

I've really no idea what you mean here, sorry. Could you try to re-explain your goal? It would likely be far more useful, as well, to provide more sample data....

Seeing as you get the error in both 32 and 64 mode, this suggests you have neither the 32 or 64 bit drivers installed. I'm also guessing that, maybe, the...

That SQL, on it's own, won't send an email anyway. How are you sending the email, via sp_send_dbmail? Can you include your FULL SQL, including the part that sends the...

How was it being run old SQL Server? Using something like EXECUTE AS with an SSISDB task doesn't work; the task must be run under the context of the user...