Magic Finserv Interview Question

Performance tuning in sql server?