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

How the authentication mode can be changed?

1089

Mention the differences between substr and charindex in sql server.

998

Write an sql query to find first weekday of the month?

878

What do you understand by triggers and mention the different types of it?

889

When do you think a developer should use sql server-based cursors?

990

Mention the differences between having and where clause.

1011

Explain the usage of floor function in sql server.

926

What do you understand by replication in sql server?

1003

What do you understand by hotfixes and patches in sql server?

925

Mention the different authentication modes in sql server.

975

Mention the 3 ways to get a count of the number of records in a table.

936

Mention a few common trace flags used with sql server?

895

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

918

What do you understand by coalesce in sql server?

1015

What do you understand by mirroring and mention the advantages of the mirroring?

1016

Un-Answered Questions { SQL Server }

What is TDS(Tabular Data Stream) Gateway?

121

How do you improve the performance of a SQL Azure Database?

135

Explain the first normal form(1nf)?

979

How to skip remaining statements in a loop block using continue statements?

944

what are cursors? : Sql server database administration

1012

What is b tree index?

864

What is rs.exe utility?

152

What are diverse clauses that form a part of sql?

1033

What is the contrast between sql and mysql?

1056

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

1063

What is an example of a primary key?

925

what is raid and what are different types of raid configurations? : Sql server database administration

986

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

1033

What is always encrypted?

952

How do I find sql server instance name?

926

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