Q:

SQL Server, Random Auto sticking to the bottom

What's going on with this.. 
Primary Key, Not Null, Auto
One row just sticks to the bottom.

Not a big deal, just wondering for future reference and to satisfy my curiosity.
Thanks.

A:

For SGBDs, tables are un-ordered sets of records, this is from the very Set Theory and Relational Algebra where SGBDs are built upon, and means that, although there's a physical order for records, this should not matter and SGBDs are not obliged to keep any consistency unless ORDER BY clause is used.

