Thanks, guys. SPs appears to be the resounding favorite.

da-zero (9/20/2010)

---

In our environment they are against using stored procedures, for the simple reason that if you deploy your SSIS packages, you could forget to deploy your stored procedures. And...

That's the way I lean, myself, but have never been entirely confident about it.

Thanks for giving the argument some weight.

Matt Arpidone (1/30/2010)

---

Thanks Mike, I'll keep in mind that any criticism of articles or disagreement will be met with animosity. I guess my opinion isn't welcome unless I agree...

Great article!! We use this exact technique in our ETL and it's great to see such solid confirmation that we have chosen a good strategy.

Two comments.

1. Why did you include...

Follow-up question: Can I use a rotating window scenario here?

This way I can reuse the existing filegroups after we reach 36 months of data.

Of course, we would archive off and...

We are joining a somewhat large fact table with dimensions and I am going to put the fact table and dimensions on different LUNs.

Your answers were exactly what I...

Andy Warren (10/20/2008)

---

I find that the trap most people fall into (including me occasionally) is that enough seems to keep moving upward and then you're just on the treadmill. Are...

We are running our startup using 37Signals' Basecamp project management tool and have been very productive. Our company is able to operate by only meeting once every two weeks. In...

Happy birthday, Steve!

My wife and I are living separately because of our aspirations; she is in Miami, FL doing her medical residency, and I am in Ann Arbor, MI building...

Preventing workers from spending time "not working" boils down to control. Humans are naturally averse to situations we can't control (risk averse). This is why many people are more afraid...

physic77 (8/15/2008)

---

Chalk up one more for the martial arts geeks, I did about 5 years of Ju Jitsu and about 3 years of TKD a number of years back, and...

This is why every form/kata that I've ever...

abatej (8/14/2008)

---

I find it interesting that there are so many of us that are also martial artists. I have just recently passed my 1st dan black belt test in...

GilaMonster (8/14/2008)

---

I tried Kendo for a bit, didn't really enjoy it. Too much focus on point scoring and competition and that's not what I look for in martial arts. I'd...