What is Dense Rank? Write query to delete duplicate records. What are clustered indexes? How will you optimize preformance of queries? What is execution plan? What is trigger? What is CTE? Difference between stored procedures and functions? What are magic tables? What are cursors? Difference between temporary table variable, temporary table and gobal temporary table?