Function - SP - Pivot - Cross Apply - Outer Apply - Truncate Table - Sparce ,- etc
Stored Procedures - Return Value - Output - TVP - Pivot
Rank - Dens Rank - NTile - RollUp - Cube
Pivot - Stored Procedure
Family - Exists - Ranking Functions - Row Number
Union - Subquery - Self Join - Family DB