BOL: http://msdn.microsoft.com/en-us/library/ms174269.aspx

How do you do the import?

If you use BULK INSERT, http://msdn.microsoft.com/en-us/library/ms188365.aspx, there's a batch size parameter, which will load xx rows in a transaction and then commit.

There are similar things...

Replication can have delays, and it's not a scale out solution. It can mimic it if the loads are not too high, but there's no guarantee that one node will...

Setup will handle this for you.

Measure the usage of various instances, keeping in mind CPU and disk. RAM is hard since they tend to use all memory, but look at #s of connections and transactions...

Martyn Hughes (10/19/2010)

---

My comment is not meant to be 'snarky', I'm always troubled when I have to fight within an organization to get useful tools. Pervasive does cost several thousand...

Amazing. I thought I'd be way down, but managed to get close.

I'll try to do better next week

Prophet

Well I rarely leave the small area I live in, but Hidden Mesa is a nice place for me to run, or my wife to ride horses.

I think there's a little elitist mentality, but someone ought to know how to do this in scripting. It's much more efficient, especially when you start getting lots of logs...

Martyn Hughes (10/19/2010)

---

I don't know why you'd want to go to such lengths to use SSIS, just use Pervasive (formerly Data Junction). It's a far superior way of getting data...

WayneS (10/18/2010)

---

... we need several hundred years of records to know this, and we barely have one hundred. I also believe that this whole global warming stuff is all politicalized...

nelsonj-902869 (10/19/2010)

---

...

Where I work, we make servers go five to seven years, not just two. We can't afford to be on the cutting edge of technology, since the edge seems...

I think a lot of cities in the NE do that. Syracuse University used to capture some steam from power generation to heat the buildings.

I'd think that a well designed...

I'm with Lynn. I'm not sold that global warming, even if it is happening, is a bad thing. It might be part of a long cycle of the Earth. My...