BCP native format is just that - native.

SSIS flat file source would not understand the file as it is binary and not necessarily clear text.

As said, you have to bcp...

if the data in Excel is relatively flat, you can use the OLEDB source component and using Jet.

See http://support.microsoft.com/default.aspx/kb/321686 for an example.

You can then schedule this package or run it...

Ever played "Corporate Bingo" in meetings with people like that?

Have a grid of (Must be current) kewywords. Each time they use a word, strike it out. When you have a...

Regarding

"The defrag that comes with win2k3 is capable of defragging the files while sql server is online, it's a huge I/O hit and the server is pratically unusable;...

Anyone? has MS forgotten about us again?

Just taking an absolute stab in the dark here. Are your columns names? If so, sorry, no clue.

But it's not...

Two be honest, I have not delved into what the partial does but the flaw would still exist.

Yes, I have tried it and it's far slower.

Two things I...

hmmm, hit a nerve then...

I actually got a Conchango SQL 2005 Edition of snakes and ladders sitting on my desk. Never played it...

Point taken but in my original post I was having a bit of a rant.

But look at it realistically. MS are doing a...

Yippee. Someone who shares my problems.

Jamie, 20 million against 830. Nice. Must have hurt when you first ran it.

But this defeats the object. I am loading 1000 records from a text file. At the time of doing the lookup I do not know what those records are. They...

To try and answer your first question:

If you only have a few rows (couple could be a few) in a table, SQL creates those pages on an extent which is...

On a whole, a good article.

One correction though.

When CREATE INDEX, WITH DROP_EXISTING is executed on a clustsered index, all non clustered indexes have to be...

DisKeeper claims to be able to defrag locked files.

I've used it a couple times in production.

A very nice feature it has is that it monitors the IO queue. If...

If saying God Bless You and God Be With You and the like is wrong, is saying May The Force Be With You wrong?