I have seen several people make this assumption over the past few weeks, and thought I should write up a little something to drive the point home.  Primarily people are expecting to take a flat file, like a log file, bulk insert it into SQL Server, and expect SQL Server to ''remember'' the original ordering of the file.  Some even go to ...