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?

1049

Can we call stored procedure in trigger?

950

How do triggers work?

932

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?

939

What does set rowcount do?

909

What does dml stand for?

947

What is ddl and dml commands?

903

Can we use trigger new in before insert?

921

What is 2nf in normalization?

997

What triggers long term care?

1034

What do you mean by cardinality?

903

Un-Answered Questions { SQL Server }

What is subreport?

141

what is raid and what are different types of raid configurations? : Sql server database administration

1041

How do you improve the performance of a SQL Azure Database?

137

What are the recovery models for a database?

1103

How do you check sql server is up and running?

1001

What is a with(nolock)?

984

What is sql server database?

1009

what is hash nonclustered index

968

What are rest-style architecture's?

170

how can you check the level of fragmentation on a table? : Sql server administration

980

What is the difference between Normalization and De-normalization?

1091

What happens when unicode strings concatenate with non-unicode strings?

1092

Tell me what is sql profiler?

1027

What is the xml datatype?

1070

What is a periodical index?

927

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