There are two different strategies... one is the system... cache, I/O, memory, load balancing, splitting TempDB for each CPU, etc, etc, ad nausium.

The other is the techniques used in the actual queries...

Ah...  got it... thought you'd stumbled into something cool.  Thanks, Remi.

Yup... I agree... said something similar above.

How do you do that?  That would be most useful to me...

... or ...

"The answer is always 'NO' unless you ask"  😉

Which property of COLUMN_PROPERTY do you ask for to determine the datatype of a column and how do you use it on a system function like @@ServerName?

Heh... you mean other than hiring someone who actually "knows" SQL?  (Just having a bit of fun, Kenneth 😉 )

There are a couple of dozen articles on this forum about...

Heh... I was mostly referring to the entire process.  For example, If headers are present in the data, they must have the same number of delimiters as the data or...

YEE-HAH!  Now THAT's what I'm talking about... just received the new email response and it's a beautiful thing!  They look like this now and it's perfect...

Sql Server...

I'll second that... due to a 3rd party bit of software :alien:, we have hundreds of "usage" databases on one server... they all talk fine with each other with no...

Mr. Cranky Poopy Pants?  Well, that "depends"... 😛

Heh... If you couldn't tell, I was ticked about this particular problem a wee bit more than the others 😀  Ol' dogs CAN learn new tricks... we're just tired of...

Muhammad Furqan (22/09/2007)

---

ok, some sample data

randomdata;10/10/2007;randomdata;randomdata;

Column1;Column3;Column5;Column4;Column2;

jk adkshfjhjkfhsajkfh sda;sdfs dfasdfsda;fsdaf sadfadsfsda;

dsf;sdf;sdf;sdfds;sdfsd;

So, here is the description.

First line, i dont want it to be in the table, but contains date that i want...

Sounds a whole lot like interview or homework questions... would have loved to see the reply... "What have YOU tried?" 😀

...And, BULK INSERT, even with the use of a format file, even beats BCP.  That's because BULK INSERT is a wee bit less functional than BCP... for example, BULK INSERT...