Allscripts interview question

SQL Server Performance tuning