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 recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

962

How sql server enhances scalability of the database system?

1219

What is partitioned view?

899

Define compound operators?

913

What are the filtered indexes?

1040

Explain transaction server consistency?

973

What is it unwise to create wide clustered index keys?

1007

Explain transaction server implicit?

983

Define inner join? Explain with an example?

996

Explain the difference between function and stored procedure?

942

Explain the architecture of ms sql reporting service?

921

What is lock escalation and what is its purpose?

974

Explain syntax for dropping triggers?

928

Explain datetimeoffset data type in sal server 2008?

907

What is buffer cash in sql server?

1152

Un-Answered Questions { SQL Server }

Which command is used for user defined error messages?

1060

what is raid? : Sql server database administration

1039

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1250

Detail about the hardware which is supported by SQL server?

1063

What is the difference between commit and rollback?

942

What is difference between aggregate and analytic function?

936

What is the use of floor function in sql server?

1081

What is the new security features added in sql server 2014? : sql server security

998

Can sql servers link to other servers?

1085

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3873

How do I find sql server instance name?

960

What do you mean by normalisation?

1043

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

985

How to create a local temporary stored procedure?

998

Difference between drill down and drill through report.

956

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