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 are the advantages of log shipping?

995

Why are views required in the sql server or in any other database?

965

List the different index configurations possible for a table?

934

Where sql server usernames and passwords are stored in a sql server?

989

List the various tools available for performance tuning?

887

What is a heap?

1032

Can we take the full database backup in log shipping?

953

What are the 2 types of classifications of constraints in the sql server?

1122

What is an execution plan?

1149

What are the different types of columns types constraints in the sql server?

1080

What is the stored procedure?

1009

What are the advantages of the mirroring?

1094

What are the common performance issues in sql server?

927

What is update_statistics command?

1065

What is the command used to get the version of sql server?

1 1524

Un-Answered Questions { SQL Server }

What is a result set object returned by odbc_exec()?

1029

What type of Index will get created after executing the above statement?

1099

How to convert numeric expression data types using the cast() function?

1067

Explain Geography datatype in SQL Server

1128

What are data regions?

135

Find first and last day of current month in sql server

1028

Explain different types of self contained sub query?

1036

Why use stored procedures in sql server?

1013

Can a trigger be created on a view?

956

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1111

What is the difference between varchar and varchar(max) datatypes?

1073

What is the purpose of linked server configuration in sql server?

1048

What is sql server schema compare? How we can compare two database schemas?

1030

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

923

How to connect to a sql server using odbc_connect()?

1152

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