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 ssrs?

129

What are advantages of ssrs or why we should use ssrs?

137

What is linked report?

131

How to fine-tune reports?

266

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

310

What new data source types were added in ssrs 2014?

160

What is report rendering ?

156

You want to use a perspective in an mdx query. How do you select the perspective?

239

What are the new features are introduced in sql server 2012 reporting services?

149

When to use null data driven subscription?

206

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

155

What are the three different part of rdl file explain them?

266

What are the types of ssrs?

145

What is report snapshot?

161

Difference between Sql server reporting services and Crystal reports?

168

Un-Answered Questions { SQL Server }

What is awe?

1007

What is the difference between resultset and resultsetmetadata?

949

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

898

What is the difference between Clustered and Non-Clustered Index?

1052

Explain the steps to use transact-sql cursor?

1054

Explain log shipping?

1008

Explain optimistic and pessimistic concurrency?

991

Explain four layers of abstraction microsoft architectured?

147

Define msdb database?

1011

What are the general features of sql server management studio? : sql server management studio

1074

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1259

How are the unique and primary key constraints different?

1071

What is the xml datatype?

1053

what is the difference between count(*) and count(1) ?

1080

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?

961

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