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

Describe triggers features and limitations?

936

What is ms sql server service broker?

942

Please explain what is “asynchronous” communication in sql server service broker?

890

What are the components of sql server service broker?

957

Tell me what are the essential components of sql server service broker?

900

Do you know how to implement service broker?

893

Explain what is the main purpose of having conversation group?

894

Explain sql server service broker?

937

Tell me what do we need queues in sql service broker?

940

How to encrypt data between dialogs?

1044

Explain isolation levels that sql server supports?

997

Explain what is lock escalation and what is its purpose?

887

Explain different types of lock modes in sql server 2000?

895

What are the different types of lock modes in sql server 2000?

893

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

900

Un-Answered Questions { SQL Server }

Name 3 ways to get an accurate count of the number of records in a table?

985

Can sql servers link to other servers like oracle?

799

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

1144

How do I find the sql server database version?

958

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

1019

How to send a ssrs report from ssis?

168

What is log cache in sql server?

996

What is dbcc command in sql server?

1029

can an automatic recovery be initiated by a user? : Sql server administration

912

How to override dml statements with triggers?

1100

What is filestream?

952

What are the differences between substr and charindex in sql server.

1037

How do I run sql server 2014?

943

How to list all columns in a table using odbc_columns()?

943

What is table value parameters (tvp)?

1050

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