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?

1132

Mention the differences between substr and charindex in sql server.

1050

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

919

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

936

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

1047

Mention the differences between having and where clause.

1057

Explain the usage of floor function in sql server.

964

What do you understand by replication in sql server?

1061

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

991

Mention the different authentication modes in sql server.

1055

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

978

Mention a few common trace flags used with sql server?

930

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?

960

What do you understand by coalesce in sql server?

1069

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

1068

Un-Answered Questions { SQL Server }

What are the types of sql server?

1052

Explain the relational database management system (rdbms)?

1098

Explain hostprotectionattribute in sql server 2005?

1028

what is bit datatype? : Sql server database administration

917

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1010

Explain the steps needed to create a scheduled job?

932

What is lookup override?

1040

Explain relational data?

923

Is natural join and equi join same?

971

What is the difference between writing data to mirrored drives versus raid5 drives

932

Can you name some of the dml commands in sql?

1031

Difference between primary key and clustered index?

1005

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

976

Can we use custom code in ssrs?

1115

Which tcp/ip port does sql server run on? How can it be changed?

1042

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