Replacing BCP with SQLBulkLoad

Question

Replacing BCP with SQLBulkLoad

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

peleg SSCrazy Points: 2611 More actions · Answer 1

Hi All

i am trying to implement the article on more complex XML structres, and maybe my work is for nothing beacue a deeper of more then one level of xml is not supported?

for xml how to i build a Schema for :

( i have removed some of the open/close tags beacuse then you can't see the xml!!!)

thanks in advnace

Peleg

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 2

DavidCameron - Monday, July 21, 2003 1:02 AM
This article assumes that XML is the way of the future, which is a false assumption.XML has some significant problems.1. Performance. I'm not talking about file size (and the resulting poor performance over networks), but about that fact that parsing XML is an intensive process. For one thing, you must read the entire data structure into memory because you must read to the closing tag. CSV has no such problems.2. Interoperability. XML only works with new stuff and something that can parse XML. Sure it crosses platforms, but you'll find that CSV as a format is even more accepted.Even one of the co-authors of the XML 1.0 standard has pointed out some problems with XML.Seehttp://slashdot.org/article.pl?sid=03/03/18/0712248&mode=thread&tid=95&tid=156That is not to say that XML doesn't have its place. Its place is in small applications that don't deal with much data, and/or have complicated data structures that need to be represented with XML.My impression is that XML is touted as the wave of the future by an increasingly small number of people these days.

BWAAAA-HAAAA-HAAAAA!!! 😉 I know you're probably not listening anymore but, one visit to this site and, oh my, what a prediction you made 14 years ago.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 3

I know this article is 14 years old but it's interesting to see that the grammar police were just as petty back then as they are now. What the hell do you people do when you have to work on a team of people whose native language isn't English?

@Stevan Popovski
You wrote 5 useful articles, most of them 5 star. Thanks for not letting people put you off from doing that. You should have kept writing.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)