Magnus,
> IIRC, SQL Server always creates clustered indexes by default for primary
> keys.
I think that's a per-database setting; certainly the ones I admin do not.
However, since SQL Server orders its data pages, those data pages tend to be
in the order of the primary key regardless if there is no clustered index.
--
Josh Berkus
Aglio Database Solutions
San Francisco