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 a mutating table error and how can you get around it?

1050

Can we call stored procedure in trigger?

950

How do triggers work?

936

Can we write ddl in trigger?

918

What is dbcc updateusage?

1203

What is 1nf 2nf?

1009

When would you use a before or after trigger?

907

What are .mdf files?

940

What does set rowcount do?

909

What does dml stand for?

948

What is ddl and dml commands?

904

Can we use trigger new in before insert?

921

What is 2nf in normalization?

997

What triggers long term care?

1036

What do you mean by cardinality?

903

Un-Answered Questions { SQL Server }

How to optimize stored procedure optimization?

892

Why use update_statistics command in sql server?

1051

Why we need sql server?

965

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

118

If no size is defined while creating the database, what size will the database have?

991

What happens if null values are involved in datetime operations?

975

How do I know if localdb is running?

953

How to backup SQL Server Reporting Services ?

148

Difference between primary key and clustered index?

1005

What is measure group, measure? : sql server analysis services, ssas

1013

How to execute the cursor queries with "open" statements?

1180

Explain indexed views and partitioned view with their syntax.

1146

Explain filtered indexes benefits?

1000

What is PROJECTION Operation?

1020

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1021

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