SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What is a not null constraint?

1034

What is the use of “join” in sql server?

1090

What are the steps you will take to improve the performance of a poor performing query?

979

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

973

What will be the maximum number of indexes per table?

962

What xml support does the sql server extend?

1011

What is a join in sql? What are the types of joins?

1105

What do you mean by data integrity?

1068

How can we determine what objects a user-defined function depends upon?

1012

What is the cartesian product of the table?

955

What is a deadlock and what is a live lock?

1001

Explain unique key in sql server?

1008

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

958

What is the difference between primary key and unique constraints?

962

Write a sql query to display the current date?

1093

Un-Answered Questions { SQL Server }

What is a transact-sql statement?

1059

What is cursors?

1186

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1043

What is cross join in sql server joins?

1142

What is the difference between row_number and dense_rank?

881

How to loop through result set objects using mssql_fetch_array()?

1076

How exceptions can be handled in sql server programming?

1012

Is it true, that there is no difference between a rule and a check constraint?

1055

What is sql service broker?

982

What is openxml in sql server?

1168

What are the different sql server versions?

980

Explain system functions or built-in functions? What are different types of system functions?

979

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2362

What is tablesample?

1110

How to optimize stored procedures in sql server?

1185

For More Un-Answered { SQL Server } Questions Click Here