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 objects does the fn_my_permissions function reports on? : sql server security

1007

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1055

Differentiate between a having clause and a where clause.

930

Explain the stored procedure?

1001

What functions can a view be used to performed?

1010

Describe the functionalities that views support.

1067

Explain primary key?

908

What are partitioned views and distributed partitioned views?

988

What are the basic functions for master, msdb, model, tempdb databases?

1006

Explain the concept of recursive stored procedure.

891

What do you mean by an execution plan? Why is it used? How would you view it?

885

What is dbcc? Give few examples.

966

What is row_number function?

949

What do you mean by an execution plan?

1063

What is a trace frag? Where do we use it?

1056

Un-Answered Questions { SQL Server }

What happens when converting big values to integers?

964

How to create a user to access a database in ms sql server using "create user" statements?

916

What is built-in function?

944

what is a check constraint?

1048

Why do we use trigger?

926

What is transaction server explicit transaction?

979

What are tables in sql server?

979

What is RMS migrations?

2101

How optimize sql query with multiple joins in sql server?

842

What are trace files?

906

What is service broker? : sql server database administration

946

What is the report model project?

133

How to add a new dsn with the odbc driver for sql server?

1017

Why normalization is used?

970

Ms sql server index?

1023

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