I'm not aware of something inherent in 2016 that would make that run slower. You are going to be dealing with the new cardinality estimation engine (at lease when the...

It sounds like your machine is completely underpowered. You need memory. I/O implies disk, but it includes reads and writes to memory plus reads and writes to disk. If you...

Connecting from ADO in Powershell should be the same as VBA. I use the full server name provided: xxx.database.windows.net. That ought to work for you. You will need to make...

There are a bunch of things it could be, probably most of them on the client side. However, the paranoid DBA in me says, check for corruption of the database...

The ATTACH function is what you're looking for to "open" an MDF file. This does assume you have some version of SQL Server installed. SQL Server Express edition...

If you can use an ALTER, do that. It won't work in every situation and then you'll need to CREATE the new table, migrate all the data and constraints as...

How about a UNION ALL where you hit the table over & over filtering only on each individual datetime?

Not sure that'll be faster, but it's different than an...

The Microsoft documentation will get you going. You can remove the master key and the certificate as well as the database encryption key,...