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 the fillfactor concept in indexes?

1035

What is ms sql server reporting services?

1123

What is the architecture of ms sql reporting service?

1026

Explain ms sql server reporting services vs crystal reports?

975

Do you know what are the reporting services components?

1020

Explain how does the report manager work in ssrs?

999

Explain having clause?

1028

Define tempdb database?

1040

Explain the microsoft sql server delete command?

1079

What is the use of stored procedure?

980

What is log cache in sql server?

1097

Define msdb database?

1077

Define right outer join?

1016

What is nested transaction?

1137

What are the differences between clustered and non-clustered index?

1076

Un-Answered Questions { SQL Server }

How to disable a login name in ms sql server?

1176

How many full-text indexes can a table have?

1025

How we can refresh the view?

1158

What are the properties of sub-query?

1131

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1059

How many instances per computer are there in sql server 2000?

1118

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

246

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1118

What is resultset concur_updatable?

1053

What are sql server procedures?

1035

Explain the usage of floor function in sql server.

1019

What is mean by candidate key?

1061

What are the disadvantages of primary key and foreign key in SQL?

1151

What is set nocount on and what is set nocount off?

994

what is the difference between delete table and truncate table commands? : Sql server database administration

1080

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