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

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1004

Explain why variables called the most powerful component of ssis?

1172

Explain the use of containers in ssis and also their types?

1017

What is precedence constraint?

1035

Why variables called the most powerful component of ssis?

1123

Explain error handling in ssis?

1070

What are the types of containers in ssis?

1232

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

1027

Explain the use of containers in ssis?

1014

Why is the need for data conversion transformations?

1111

What is conditional split?

1141

Can we add our custom code in ssis?

1040

Explain the difference between control flow and data flow?

1057

What are the purposes and advantages stored procedure?

1018

Determine when to use stored procedure to complete sql server tasks?

1107

Un-Answered Questions { SQL Server }

How to create percentile function?

159

What is the difference between clustered and non-clustered indexes in ms sql server?

1052

What are alternate keys?

1029

Why use view instead of a table?

1003

Where are stored procedures in sql server?

1124

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1095

How much memory that we are using in Logshipping Concept?

1844

What are the dis_advantages of stored procedures, triggers, indexes?

2273

How to implement service broker?

1070

What is the recursive stored procedure in sql server?

1077

What are the different types of collation sensitivity?

1176

How to create an identity column?

1301

Difference between drill down and drill through report.

1003

Explain the difference between cross join and full outer join?

1033

How to create prepared statements using odbc_prepare()?

1101

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