Rob Farley offers some advice:
Following on from my last post… what advice would I give about T-SQL to my younger-self?
Well, for that I’m going back a long way. To when I had learned about queries, but still had some way to go.
It’s the same advice I give to everyone who’s learning to write T-SQL, even the most basic of beginners. And that is to understand that the queries you write get turned into execution plans, and it’s them that actually run.
Read on for some good advice.