Use table-valued functions over scalar functions Use partitioning to avoid large data moves Use stored procedures for performance, use ORMs for convenience Retrieve only the columns you need ...