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?

1126

Can we call stored procedure in trigger?

997

How do triggers work?

994

Can we write ddl in trigger?

969

What is dbcc updateusage?

1257

What is 1nf 2nf?

1060

When would you use a before or after trigger?

955

What are .mdf files?

1016

What does set rowcount do?

961

What does dml stand for?

994

What is ddl and dml commands?

958

Can we use trigger new in before insert?

962

What is 2nf in normalization?

1055

What triggers long term care?

1087

What do you mean by cardinality?

940

Un-Answered Questions { SQL Server }

How many clustered indexes there can be on table ?

1071

What is it unwise to create wide clustered index keys?

1044

Explain the functionalities that views support?

1162

How to attach adventureworkslt physical files to the server?

1160

How to choose all records from the table?

1102

How to delete duplicate rows in sql server?

1152

whats the maximum size of view state??

2248

Is truncate a dml command?

998

How to concatenate two character strings together?

1166

How to provide login information for a new odbc dsn?

1094

What is deploy, process and build? : sql server analysis services, ssas

1154

how to control the amount of free space in your index pages? : Sql server database administration

1085

How to provide values to stored procedure parameters in ms sql server?

1097

Does sql server 2000 clustering support load balancing?

1025

what is an extended stored procedure? : Sql server database administration

1109

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