50 Frequently Asked SQL Server Interview Questions – Part I

How will you to performance tuning ? https://www.youtube.com/watch?v=P97_oFfD218 What will you look for in an execution plan ? http://www.mssqltips.com/sqlservertutorial/285/query-execution-plans/ What is bookmark look-up related to execution plan http://www.qdpma.com/CBO/s2kCBO_2a.html Table variables vs temp tables http://engineering.picscout.com/2012/04/ sql-temporary-tables-vs-table-variables_17.html How do you pass output parameter in a stored procedure... If you specify the OUTPUT keyword for a parameter in … Continue reading 50 Frequently Asked SQL Server Interview Questions – Part I