Sort order issue when moving sdf files between platforms

Jim Wilson describes an index rebuild issue that occurs when moving SQL Compact database files from one platform (Vista or Server 2008) to a mobile device.