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?

1122

Can we call stored procedure in trigger?

994

How do triggers work?

991

Can we write ddl in trigger?

963

What is dbcc updateusage?

1251

What is 1nf 2nf?

1057

When would you use a before or after trigger?

952

What are .mdf files?

1012

What does set rowcount do?

956

What does dml stand for?

991

What is ddl and dml commands?

955

Can we use trigger new in before insert?

955

What is 2nf in normalization?

1050

What triggers long term care?

1083

What do you mean by cardinality?

938

Un-Answered Questions { SQL Server }

What is dirty page?

1030

How many triggers you can have on a table?

1032

What does this statement do @@rowcount?

1011

Is it possible to call a stored procedure within a stored procedure?

1024

How to see the event list of an existing trigger using sys.trigger_events?

1125

Explain about protocol layer present in SQL server?

1286

What is cached report?

150

List some of the rules that apply to creating and using a ‘view’

920

Tell me what do we need queues in sql service broker?

1048

Does transparent data encryption provide encryption when transmitting data across the network?

1095

Explain how to maintain a fill factor in existing indexes?

1035

What is a rownum?

1056

Explain the concept of recursive stored procedure.

1019

What is the recommended total size of your memory optimized tables?

1004

What are the tools available in market as an alternative to sql server reporting services?

138

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