Skip to contentSkip to footer

Sql Server Interview Questions

Salaries
Interviews

237 sql server interview questions shared by candidates

what is materialized view and why it is required?what is pivot? when to use the non-clustered index and when to use clustered one.what will you do if your database is growing out of size?how to optimize the query or stored proc? how to read execution plan and what steps to take on it? write query which can add row number column for a table? what is partition? diff between temp table and temp table variable? scope of global variable? there are two tables both have only one column which accepts null, both table have 5 rows as 1,1,1,1,null. how many rows will come for inner join, left, right, union and union all on these two tables.(try this on SSMS)? High level design for employee, tasks and timesheet scenario etc
avatar

SQL Server Developer

Interviewed at Fulcrum Worldwide

4★
Jan 20, 2014

what is materialized view and why it is required?what is pivot? when to use the non-clustered index and when to use clustered one.what will you do if your database is growing out of size?how to optimize the query or stored proc? how to read execution plan and what steps to take on it? write query which can add row number column for a table? what is partition? diff between temp table and temp table variable? scope of global variable? there are two tables both have only one column which accepts null, both table have 5 rows as 1,1,1,1,null. how many rows will come for inner join, left, right, union and union all on these two tables.(try this on SSMS)? High level design for employee, tasks and timesheet scenario etc

Very basic sql questions, like what is a constraint, primary key, how to join tables, inner join, left outer join, what is the difference and some basic programming question, what is an object, how to inherit from a parent class, write a program for prime number, so this is basically the type of questions you will encounter depending on what you have written on your resume
avatar

SQL Server Developer

Interviewed at CCS Global Tech

4.3★
Sep 20, 2014

Very basic sql questions, like what is a constraint, primary key, how to join tables, inner join, left outer join, what is the difference and some basic programming question, what is an object, how to inherit from a parent class, write a program for prime number, so this is basically the type of questions you will encounter depending on what you have written on your resume

Viewing 181 - 190 interview questions

Glassdoor has 237 interview questions and reports from Sql server interviews. Prepare for your interview. Get hired. Love your job.