Ayup, Jim. I'm not sure why all these younguns are worried about how fast da stream goes. *rocks a little more, scares the crap out of the cat*....

GilaMonster (4/25/2011)

---

2/3 c,...

*sits on his porch, sippin' another bit of moonshine, listenin' to Tom and the others discuss wirin' speeds*

Yep, that them there sounds fast. Duke boys could still out run...

Phil Parkin (4/22/2011)

---

Actually, I think there is quite a nice way for SSIS to handle this - using...

Yeah, somehow I missed that. Twice....

Syed Jahanzaib Bin hassan (4/24/2011)

---

Data 1 (foir base tables)

Data 2 (for transaction tables

Index 1 (for base tables indexes)

Index 2 (for transaction tables indexes)

Log 1 (Primary Log File)

Log 2 (Backup If...

crainlee2 (4/23/2011)

---

Regarding Paul Randall's quote: "Update statistics for all of the non-indexed columns", it would seem that there is a flaw in that statement, since statistics are only kept on...

Holy Spam, Welsh. Think it through, read it over, make sure it contains what you want to say, then hit post.. or even Edit. Postcount doesn't mean much...

No worries about anything adversarial, you're not. As long as you forgive me the lack of tone in text, we're good. 😉

Jeff Moden (4/23/2011)

---

Files with fixed width fields are...

Phil Nicholas (4/23/2011)

---

Well often dialogs consist of a list of stuff with no guidance and worse hide stuff that are critically important (see analysis services dialogs). The bol was reset...

LutzM (4/23/2011)

---

Most of the time I end up using SSIS to call T-SQL sprocs though...

The other "benefit" is maintainability by those folks used to drag & drop (aka "click here...

Jeff Moden (4/23/2011)

---

Understood. But the "old school" ways do work quite nicely including such things as you mention like incrementing file names, etc, etc. And, there's usually no...

You're thinking like an administrator, not a developer, Jeff.

Most places restrict, or outright deny, xp_cmdshell any access.

Now, to save you the argument, your SQL Agent probably isn't restricted...

I'll flip your concerns. I know a smattering of .NET (VB, C#, or otherwise). Could I probably build a file looper or some kind of streaming data lookup?...

If...