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 does the report manager work in SSRS?

158

Can you always create a cache of a report?

178

Difference between Logical Page and Physical Page in SSRS.

491

Can you edit the .rdl code associated with a linked report?

168

What type of Index will get created after executing the above statement?

1149

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1088

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1141

What do you think of this implementation? Can this be implemented better?

1000

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1247

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1222

What is the New in SQL server 2008?

1017

What are the types of indexes?

1136

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1174

Explain four layers of abstraction microsoft architectured?

147

What are the advantages of sql azure?

140

Un-Answered Questions { SQL Server }

What are the different kinds of ssrs reports?

221

Explain what is analysis service repository?

1051

What are the advantages of paper records?

1014

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

1042

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1011

What is an example of a foreign key?

1033

How to configure odbc dsn with different port numbers?

1156

How to add additional conditions in SQL?

1071

Explain temporary table vs table variable by using cursor alternative?

1055

Does group by sort data?

949

How optimize sql query with multiple joins in sql server?

958

What is the difference between functions and scalar functions?

1287

How to execute stored procedure and set temp table in sql server?

1101

Tell me what do you understand by a view? What does the with check option clause for a view do?

1064

What are the export options of ssrs?

178

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