I assume the source file does not contain a processed_flag or processed_date column. I just ran a quick bulk insert test and when I added an extra column to the...

I would look at some tutorials and script it yourself. This link has an example of a partition scheme based on months, but it would be easy to modify for...

Do either of these give you what you need?

--ONE ROW PER NAME WITH COUNT
SELECT firstlastmerged,
       COUNT(firstlastmerged) AS Cnt
FROM   dbo.YourTable
GROUP...

Tabular models are loaded into memory when the instance...

It looks like it runs the query to see if any data will be returned in order to make @@ROWCOUNT >0. Either set a variable to the count, or just...

My understanding is that there is a 16 GB limit for RAM per tabular instance.

https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16#Cross-BoxScaleLimits

If the total used by all databases is 5GB you should be fine. I...

I believe SQL Server Standard limits a tabular instance to 16 GB. It sounds like you may be getting close if you have seen it max out around 12. Is...

It's been a long time since I had to deal with this problem, but I think it helped to run a process clear before process data. According to the link...

I imagine the suggestion will be to simply get rid of the index reorg task, however, I think the maintenance plan is essentially an SSIS package.  You may be able...

I found that a simple example generates the error above if you use CHAR(13) alone as a line break (which was in my suggested solution). Scott's solution used CHAR(13) +...

Did you try executing the code as well as printing? Print can only return 8k so it will truncate the variable if it's longer, but you can execute dynamic sql...

Here's a rough go at it. It seems to work in my environment, but any really wide table will be a problem for PRINT. I would not blindly run a...

Have tried the Microsoft Connector for Oracle? I found it worked right away, no need for an Oracle client or tnsnames. In the past I have failed miserably in trying...

Hi, thanks for the advice. The database in question is interesting in the sense that its a financial number storing database whose values are rebuilt (ie lots of calculations...

If the ETL is set to continue on failure, it should still log errors to the SSIS catalog (if you're using it) so they should be possible to query.

I would...