SQL Server rewards a few good habits: index your most-filtered columns, keep statistics up to date, and read the actual execution plan before guessing at performance problems. Prefer set-based queries over row-by-row cursors, and watch out for implicit conversions that quietly kill index usage. When something feels slow, start with wait statistics and the query store—they usually point straight at the real bottleneck.