Pergunta de entrevista da empresa GGK Tech

1.How do you tune a long running query 2.Tell me about difference between stored procedure, functions 3.Difference between CTE, Temporary Tables and Table Variables. 4.Indexs 5.Write query based on the table data.