I was just trying different things as I'm going through a book and created a table called brokers
fname varchar
lname varchar
email varchar
lname, fname is a clustered index
email is the unclustered primary key
when I "SELECT * FROM brokers" it sorts by email??? If I remember right, everything I've read says that a table will be sorted by the clustered index.
If I create the same table with an identity column as a non-clustered primary key it sorts just as it should using the clustered index.
Why does using a varchar/char for a primary key make my clustered index sort different?
thanks,
Chuck Dearbeck