sql server programming: As I understand it, binary is the fastest sort order. Could anyone ballpark the kind of improvement in performance of binary over DOCI?

Would it be relatively minor like 2-5% or something more significant

Thanks
Dea

[quoted text, click to view]

It used to be that number you spoke about, say, 5 years ago. Currently we
have pentiums until 4GYGAbyte and the C++ language and SQL server has
improved such that it does not really matter.
What matters, is the size of data that needs to be written. The lesser pages
written to the (relativelyslow!) disk, the better the scalability.
Further, I've never seen any hints from experienced DB admins and from the
SQL server team, to keep up with binary sort orders.