You can usually identify that you need more memory if you can see that you are experiencing memory pressure.

This is an article that helps to identify memory pressure

http://www.sqlskills.com/blogs/jonathan/identifying-external-memory-pressure-with-dm_os_ring_buffers-and-ring_buffer_resource_monitor/

And this one

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

you are welcome.

Aeterna (5/19/2014)

---

I'd also suggest going over the contract in detail and be prepared to reject any job offer if you don't like the contractual terms. Companies will then either refuse...

This is the same approach...

You have used multicast to send data to two databases at the same time. You want to execute a stored procedure in each of those databases after the data...

ihpk74 (5/21/2014)

---

do appreciate your prompt response. also wondering, after loading data into tables, i do want to go back to control flow and run the stored procedure in both databases....

EventClass

Multicast is the appropriate transformation to use.

From the additional information, it sounds like the same approach I would take.

No. You won't be able to do that and use the GO command.

Have you verified the existence of null values in the ProductVersion column?

Very good. Another superb example of implicit conversions gone wild.

Nice experiment Hugo. Saves me the effort!!

The same exact data into multiple tables?

or

Different pieces of data into different tables depending on the criteria?

There is so little information here, we'd really just be throwing around guesses trying...

Revenant (5/20/2014)

---

Ed Wagner (5/20/2014)

---

crookj (5/20/2014)

---

eccentricDBA (5/20/2014)

---

Ed Wagner (5/16/2014)

---

History (I know what you mean. I love playing strategy board games like...

In that case, it really boils down to knowing your boss and your environment. Which metrics do you feel are important vs. which are important to the boss? ...