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 updatable resultset?

1008

Is port 1433 secure?

997

How do I open port 1433?

932

What is meant by dirty read?

996

How does recursive cte works in sql server?

1016

What is correlated subquery in sql server?

1073

What do you mean by sql server 2005 express management tools?

1308

Can we use max in where clause?

925

What is the use of group by clause?

943

Can we use where and having clause together?

1046

Can we use where clause with group by?

904

Can we use where clause in union?

1069

Can we use having clause without group by?

980

How do I create a stored procedure in dbml?

1009

What is db stored procedure?

880

Un-Answered Questions { SQL Server }

Explain what is the difference between a local and a global temporary table?

1003

What is ddl and dml commands?

906

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1059

What is sql server locking?

996

Can primary key be a foreign key?

1059

Explain the difference between HTTP and HTTPS in database?

1037

What is an indexing strategy?

1010

why would you call update statistics? : Sql server database administration

1089

What are the parts of a function?

942

What is index, cluster index and nonclustered index?

996

What is the difference between stored procedure and user defined functions?

1191

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2348

What is stretch database in sql server?

1066

What is the difference between a check constraint and a rule?

1253

What is shared lock?

905

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