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?

1081

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

903

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

942

What is the boxing and unboxing concept in .net?

917

What is the log shipping?

1001

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

947

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

991

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

979

What is the dbcc command and why is it used?

1052

How will you decide the active and passive nodes?

1128

How can you hide the sql server instances?

1021

What is the difference between value type and reference type?

920

Define magic tables in sql server?

1055

Explain different types of collation sensitivity?

982

What command is used to rename the database?

1011

Un-Answered Questions { SQL Server }

Explain system rowset functions?

999

Do I need a report server to run reports in my application?

165

How to drop an existing stored procedure in ms sql server?

1032

What is the use of nvl work?

1004

What are the fixed server level roles? : sql server security

1128

Is sql server is free?

981

Do you know how to send email from database?

1005

What is the most common type of join?

988

Explain transaction server distributed transaction?

979

Write SQL queries on Self Join and Inner Join.

1154

What command is used to delete a table from the database in the sql server and how?

1113

What does truncate do?

935

Which are the olap features?

957

How to read data in a table with "select" statements?

967

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1001

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