Which is faster join Which is faster

SELECT * FROM X INNER JOIN Y ON x.Record_ID = y.ForignKey_NotIndexed_NotUnique


or

SELECT * FROM X INNER JOIN Y ON y.ForignKey_NotIndexed_NotUnique = x.Record_ID
There will be no difference - the query engine in mssql (and in most database engines) will build the same query plan for both.  You can verify this by viewing the estimated and actual query plan in SQL Workbench.