Magic Finserv interview question

Performance tuning in sql server?