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

Can I run multiple instances of sql server 2000 at the same time on one computer?

1070

What are the different types of replication are there in sql server 2000?

1036

What are system databases into sql server (2005/2008)?

994

How many database files are there in sql server 2000?what are they?

1048

What are sparse columns?

1007

How can we rewrite sub-queries into simple select statements or with joins?

974

What does the on delete cascade option do?

1013

How are the unique and primary key constraints different?

1069

What are the advantages of using cte?

1008

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1095

How to find tables without indexes?

1086

What is a collation?

1084

How many instances per computer are there in sql server 2000?

1062

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1027

What is a raid and what are different types of raid configurations?

1262

Un-Answered Questions { SQL Server }

What is 2nf normalization?

1014

What happens if date-only values are provided as date and time literals?

1015

What do you understand by SQL*Net?

1019

Explain the dbcc pintable command when would you use it?

910

what are defaults? : Sql server database administration

1082

What is data compression?

987

How can you list all the table constraints in a database?

934

Explain the dirty pages?

997

How raid can influence database performance?

1021

What is a mutating table error and how can you get around it?

1040

What xml support does the sql server extend?

1003

What is stored procedures?

1022

What is triggers and its types?

1005

How to create a simple user defined function in ms sql server?

1012

What is trigger explain with program?

973

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