This is a pretty big topic for sure. Replication is your friend for this kind of thing. You will need to do a bit of research on replication so you...

This is an excellent explanation of what you witnessed. http://blogs.msdn.com/b/conor_cunningham_msft/archive/2008/08/27/no-seatbelt-expecting-order-without-order-by.aspx

You say it isn't returning what you want, what do you want it to return. For two dates say '20170101 10:34:000' and '20180418 13:34:000' what should be returned?