Try using BULK INSERT.... WITH (CODEPAGE='RAW')?

Seems to work for me (from a cut and paste from your post).

Performance-wise - it is usually better to make your files "big" so that they don't have to auto-grow. The problem with auto-grow is that it will almost invariably happen...

Assuming you easnt to use "native" SSIS functions, you're going to want to look at the lookup tasks, conditional split and data conversion tasks, and how to use the "errors"...

Float and Decimal math are two entirely different "animals". From what you seem to be talking about - you're going to want to steer towards decimal types, which are...

Nisha (2/4/2008)

---

Could you tell me how exactly I'm supposed to know if my tempdb is full?

It's set to unrestrictive growth by default, right?

And what about the Temp folder? When...

What does DBCC OPENTRAN mention?

If there are open transactions, then try a COMMIT transaction, or a ROLLBACK until such time as nothing is left open. Obviously you'd...

Yes - if you don't make your clustered index unique, you certainly can have dupes in your clustered index Keys. To account for that, SQL will add some hidden...

Also - depending on which one you're in - there's an option in the scripting category to "create scripts with compatibility for SQL2000" or something very closely related to that....

If you can afford the sticker shock - stick with the Core 2 duo's T7000 and higher. They've included some nice chipset improvements to memory management and cache pipelining...

If you're looking to improve your performance - you need to ditch the inner cursor. Selecting one row at a time, and process updates one row at a time...

Peso (2/5/2008)

---

My suggested algorithm fetches only the top 10 records based on the column that ranking is calculated on.

I then calculate the ranking for only these 10 records.

Then I eventually...

The default behavior with division on SQL Server is to return the SAME datatype as the starting columns. So if ColA is an integer, the result of ColA/5 would...

I think the flaw in the whole "equity" thing so prevalent in HR these days is that is has the effect of "dehumanizing" the process. As Steve said very...

Are you looking to make sure you run this process on EXACTLY 1M rows, or just looking to limit the recordset? I mean - creating a new ID isn't...

Notice that my latest calls your Temp table solution, the CTE solution.

You really should give some of this a whirl. Running RANK() to the whole set just...