To find the size of the procedure cache used for a sort (used by create index, update statistics, order by,distinct, sort and merge join), first determine the number of rows per page:
Determine the procedure cache size used for a sort with this formula:
If you use a 64-bit system, use 100 bytes in this formula.