I've got this table - it's huge, not by data volume standards ( ~ 45 million records and growing w/ projected exponential growth ), but by load-time standards ( ~ 25 hours to do a full load ).I need a way to speed this up. ( I'm already doing incr...
Doing some testing. I have two tables from the same source - they should be mutually exclusive result sets, but may not be. I created a third table using two SQLi -based tables to query the first two and set the key columns to eliminate any duplic...
Simple ( maybe ) question - RAM usage on a data agent is configurable, but what is the data agent doing to require RAM? I had assumed it was just a passthrough so wouldn't need to store or process any data locally, but is that the case? I've als...
When viewing the SQLi Audit log in _IncortaMetadata there are a combination of entries that are related. There is a BEGIN and COMMIT before each statement. There is also a separate set of BEGIN, and COMMIT when I sent a statement using the Initial SQ...
I have a SQL statement with a long and convoluted backstory ( tl/dr - bug making me chase workaround ) and I've come across a potential solution using cast ( <column> as numeric ) See the animated GIF at the end of this post for the perplexing probl...
