Dave,

I just setup a test. Set my collation to yours. Executed your script, recieved the same results.

Modified your script to what I had said:

CREATE TABLE tbl (x INT NOT NULL,...

David,

My next question to you after looking at your results - what is your collation and your collation sort order? Your results returned in your y column alpha-numeric.

And yes, my...

David, I am sorry but I would need to see your references on this.

When data is bcp'ed into a table, and there are no indexes of any kind, especialy clustered,...

Nick,

What argument? 🙂

Tim (and Nick)

The data is stored in the order that it is loaded. I do not think that your issue is actually how it is stored.

When you issue...

I have found that it is sometimes helpful, especially on tables which are very large and have a lot of activity. In these cases I partition the table itself, with...

If you bulk insert the file into a table without a primary key on it, the records will be inserted in the order that they are in the file. After...

Orc,

Maybe this will help you:

Memory Settings:

http://support.microsoft.com/kb/274750

You may also get some more information from http://msdn.microsoft.com/en-us/library/aa933149(SQL.80).aspx

If memory serves me on Windows 2000, you can try to set the /3GB switch as well in order to pass the 3GB limitation. It would have to be on...

Orc-91 (Sorry, just can't say that O word;-)

In order to set the AWE on, you will need to restart your SQL Server. You did say that you have the /PAE...

It was stated before - there are volumes written on how to remove duplicate records. Your case is not unique.

If you feel that these ways do not work for you,...

Kevin,

Try to drop the index and Primary Key which is involved first (preferably on a backup copy of the database) and then retry the dbcc. It appears that the errors...

Actually, the goal should be to read and think.

That being said, I...

I like it.

When a stored procedure is executed using "sp_", SQL Server checks in the master first, as "sp_" is assumed to be reserved for...

vk - Excellent question. I got it wrong, then had to re-read the question. Next time I should make sure that I read the question thoroughly.