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 trigger explain with program?

1015

What is trigger in salesforce?

1052

What is ddl command?

1033

What is difference between after and before?

1189

What are examples of triggers?

1125

What is statement level trigger?

1045

Which are ddl commands?

1113

What is 2nf example?

1052

What does it mean to invest in the index?

1019

Where cross join is used?

1028

What does <> symbol mean?

1026

What is a benefit of using an after insert trigger over using a before insert trigger?

1033

How do you delete a trigger?

1033

What does indexation mean?

1030

What is 2nf normalization?

1088

Un-Answered Questions { SQL Server }

Mention the different types of triggers?

1202

What are sql server procedures?

1035

What are types of scd? : sql server analysis services, ssas

1077

which table keeps the locking information? : Sql server administration

1140

How do you create type- insensitive operator?

1099

How to find the source of a table in sql server?

1037

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

246

How many databases Microsoft SQL server provides?

1153

Explain about unique identifier data type in sql server?

976

Is truncate autocommit?

993

Explain transaction server auto commit?

1090

What is save transaction and save point?

1256

Explain datetime2 data type in sal server 2008?

951

Do you know what is a trace frag? Where do we use it?

1040

Who is the owner of a schema in ms sql server?

1116

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