Paul White provides some great information about row goals, explaining why they're important to understand when examining why the query optimizer made a certain choice.
Erin Stellato (@erinstellato) takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures.