 <p>You can created a clustered index to keep these in the order you want.</p> <p><a href="http://msdn.microsoft.com/en-us/library/aa174523(v=sql.80).aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/aa174523(v=sql.80).aspx</a></p>