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 the use of floor function in sql server?

1125

Define the one-to-one relationship while designing tables.

936

Which is the main third-party tool used in sql server?

991

What is the boxing and unboxing concept in .net?

972

What is the log shipping?

1058

Is there any difference between primary key and unique with the not null condition?

997

In which tcp/ip port does sql server run? Can it be changed?

1035

What is "scheduled jobs" or "scheduled tasks"?

1024

What is the dbcc command and why is it used?

1105

How will you decide the active and passive nodes?

1177

How can you hide the sql server instances?

1066

What is the difference between value type and reference type?

987

Define magic tables in sql server?

1116

Explain different types of collation sensitivity?

1028

What command is used to rename the database?

1084

Un-Answered Questions { SQL Server }

Do you know concepts and capabilities of sql server?

1106

What are the drawbacks of reporting in ssrs?

159

What are the essential components of sql server service broker?

1065

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

995

What is built-in/administrator?

1071

What is an indice?

1081

Explain how to use linked server?

1031

Define normalisation?

1155

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1100

What security features are available for stored procedure?

1073

How many types of triggers are there?

1115

Can an automatic recovery be initiated by a user?

1066

What is analysis service repository?

1066

Explain ranking functions?

1094

What is acid db?

929

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