How do I see SQL sessions? If we want to store temporary data inside stored procedure what should we do? When should we go for temp tables? Difference between index seek and index char? Diff b/w view and table What are new features in SQL server 2018

Question

Accepted Answer

Answers to SQL-related questions for Senior Software Engineer position

To see SQL sessions, use the sp_who2 stored procedure or the Activity Monitor in SQL Server Management Studio
To store temporary data inside a stored procedure, use table variables or temporary tables
Use temp tables when you need to store large amounts of data or when you need to perform complex joins or aggregations
Index seek is a type of index access method that uses a seek operation to find the data, while index scan reads all the data in the index
A view is a virtual table that is based on a SELECT statement, while a table is a physical storage structure that holds data
New features in SQL Server 2018 include graph database capabilities, improved performance and scalability, and enhanced security features

How do I see SQL sessions? If we want to store temporary data inside stored procedure what should we do? When should we go for temp tables? Difference between index seek and index char? Diff b/w view and table What are new features in SQL server 2018

Top CitiusTech Senior Software Engineer interview questions & answers

Popular interview questions of Senior Software Engineer

Top HR questions asked in CitiusTech Senior Software Engineer