p.s. The steps you take to get the raw data file from wherever should also be included. Of course, no username/passwords, please.

Lowell (4/1/2008)

---

boy I really agree; It's a stupid Project requirement that all "raw data" is imported from text into SQL Server database, and then the data massaged from there. ...

Matt Miller (4/1/2008)

---

Every time I hear of a "door" like this being opened, despite all of the assurances that it's a "one-way door", there's always some smarty finding some way...

Marios Philippopoulos (4/1/2008)

---

It's not about DBAs allowing devs direct access to production. It has nothing to do with that.

It's...

GilaMonster (4/1/2008)

---

Andre T (3/31/2008)

---

Ahh, I must be confused with Oracle which would make sense.

The big picture is a bit complicated. I certainly realize set based is better but...

Marios Philippopoulos (4/1/2008)

---

It's not that bad... There are 2 basic .NET languages, and in most organizations there are policies in place that restrict .NET development to 1. In my case...

Lowell (4/1/2008)

---

I'm putting this thru it's paces now Jeff;

The data I'm trying to parse is some FIP55 data with every place name in the united states; 560 meg of data,...

Spot on Antonio... real key is that the data should never have come into the database in an unsplit fashion to begin with. They should use Bulk Insert or...

Loner (4/1/2008)

---

What if the DBA does not know anything except backup and restore database? I have seen a lot of...

Heh... I can see why... There is a bit of "religion" there...

No need...

SELECT Table_Name, Column_Name FROM Information_Schema.Columns

Start here...

http://www.sqlservercentral.com/articles/Test+Data/61572/

Heh... Never got around to finishing those... can't find any developers that can follow the first commandment...

"Though shalt have no greater database authority than the DBA."

So, you're saying that a DBA must learn all possible languages that may be compiled into a CLR and have the ability to review the source code from same? ...

No, no... that's one of the 10 Commandments of Developers...

"Thou shalt not commit RBAR" 😉