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 user-defined scalar function?

961

What are different types of collation sensitivity?

987

What are “phantom rows”?

1655

Explain error and transaction handling in sql server?

1010

Difference between primary key and clustered index?

1002

How many columns can we include on clustered index ?

983

What is a covered index?

935

Why can there be only one clustered index and not more than one?

1001

How to Check if table exists in sql server?

1133

How does using a separate hard drive for several database objects improves performance right away?

927

What are “unrepeatable reads”?

1230

What is an execution plan? How would you view the execution plan?

1073

What is the cpu pressure?

1035

What is user defined stored procedures?

930

What is sql server schema compare? How we can compare two database schemas?

1027

Un-Answered Questions { SQL Server }

Explain table valued parameters in sql server? Why tvp used?

1017

What are sub reports and how to create them?

139

Do you know sql server 2008 backup compression?

963

Define full outer join in sql server joins?

983

How to set database to be read_only in ms sql server?

1001

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1046

What is the distinction amongst delete and truncate?

1061

What is the difference between for trigger and after trigger?

1101

What is log cache in sql server?

1034

What are the security related catalog views? : sql server security

946

What is the function of sql server agent windows service?

1089

What are partitioned views?

985

Which table keeps the locking information?

917

Explain syntax for viewing, dropping and disabling triggers?

949

What are scalar functions?

994

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