Sorry I posted completely the wrong link! :blush: The correct one is:

http://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/

If I understand correctly you have set Max Server Memory to 29GB and you're seeing memory used at 75% of that figure which is 21.75GB. That is not an awful...

Similar to what sqlbuddy said, if you use a For Each Loop container to process your files, you will be storing each filename in a variable. If you then use...

But as sqlbuddy said, do you actually have a problem?

Add more memory? Investigate WHY more memory is being used? What sort of monitoring are you doing?

Regards

Lempster

There will be some sort of error message within Replication Monitor to go with the 'red' mark (a red 'X' I assume): what does the error message say?

Regards

Lempster

Use a set of staging tables either in the same database (under a different schema for ease of identification and for naming purposes - can use the same table names)...

I disagree with that statement. Sure, the relational data warehouse containing the dimension and fact...

Try setting the ParameterName field in the ParameterMapping screen to 0.

Regards

Lempster

Jeff Moden (2/28/2014)

---

Put an index on the "Current-Flag" and watch your GUI's timeout when they try to do an INSERT because of the massive extent splits that will occur. ;-)...

yuvipoy (2/27/2014)

---

Supported means that Microsoft "supports" that configuration. I have installed SQL Server on non-supported platforms and been able to use it plenty of times.

But seriously, why install SQL...

You're welcome. 🙂

Yeah, I get that.

call.copse (2/27/2014)

---

BTW much as I respect you Mr Celko, you are overly harsh above - I am fully cognisant of the correct way to do dates, unfortunately many of us...

Cracking stuff Andy! Thanks for sharing.