What are the various tools you used for Sql Server Query optimization/Performance tuning Explain how do you optimize  Server for better performance Explain how do you optimize  Database for better performance ( Explain in details about, what all we can do with TempDB for better performance) Explain how do you optimize  Query for better performance … Continue reading Performance tuning questions in SQL Server.