One more thing - make sure the ODBC DSN that you are using is the correct bitness (32-bit vs 64-bit). If the app is 32-bit, then it MUST be the...

Speed of the SSD and network latency will determine the maximum performance of the SQL instance. My understanding, if the network latency is 1 second and the SSD speed is...

My opinion - if E2 is running on a SQL Server backend, why reinvent the wheel? Use SSIS for your ETL.

If that isn't an option for one reason or another,...

Maybe this is over-simplifying the problem, but is there any reason why you can't connect directly to the data source?

In my experience, the more hoops your application has to jump...

Just my opinion, but systems with "variable mass systems" such as rockets, comets, fluid ejection, or systems with dynamic mass exchange, I am not sure what this model helps with....

I'd be hesitant to use floats personally. Main reason is that floats and reals are approximate values. See this link

PLUS if you are REALLY needing a NUMERIC(30,10), the CAST...

We actually use DH2i for handling our HA/DR, but we are only hosting a few instances in that failover - roughly 30 across all of our servers - and it...

I don't think this is a problem with "rounding" but a problem with "precision". SQL has complicated logic around precision. The below is taken from here

The...

The EASIEST way to do it is to download and install a SQL monitoring solution that watches for database growth.

If that isn't an option, you'd need something in place that...

Just my 2 cents but the example provided in the link I provided to me proves that NKTg₂ is irrelevant in that example. If you assume NKTg₂ is 0, you...

My opinion - it is LIKELY related to the job not having access to the stored procedure, but the logs will be the best way to tell what went wrong.

If...

Check the job history. That'll probably tell you what's wrong. BUT as a guess, does your SQL Agent service account have permission to run that SP?

I would recommend changing the...

I'd also like to add that AI can also give bad advice. Before making ANY changes to the system, you should fully understand the advice being given. Like if AI...

Lots of resources on dynamic SQL, but the basics of it are that you are storing your SQL TEXT in an NVARCHAR variable and then passing it to the stored...

My opinion - The first and second query are not going to be changing much, if at all as there is no logic in them, so duplicating them across 2...