OR... are you looking for things like why you might want to use Integer math, how to do things with dates and times, how to compare two differently partitioned ROW_NUMBER() results to identify overlapping events, the math behind quickly building high performance nested sets instead of using loops or recursion, why automatic conversions to decimal datatypes can suck, etc, etc?
In other words, what the hell does "all" mean in your original post? 😉
--Jeff Moden
Change is inevitable... Change for the better is not.