Mr_Shaw
asked on
Data order different on two servers.
I have a table which is replicated on to another server. On the each server the order of data is different when you do a SELECT * .
Apart from the clustered index are there any other factors which can affect data order in a table.
Apart from the clustered index are there any other factors which can affect data order in a table.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Index fragmentation has nothing to do with order shown in a SELECT *
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
ASKER
Do you think it could be a fragmentation issue?