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?

1120

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

1087

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

1047

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

1107

What are sparse columns?

1065

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

1028

What does the on delete cascade option do?

1062

How are the unique and primary key constraints different?

1127

What are the advantages of using cte?

1075

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

1166

How to find tables without indexes?

1153

What is a collation?

1131

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

1118

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

1072

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

1322

Un-Answered Questions { SQL Server }

How to delete exactly duplicate records from a table?

1110

What is replace and stuff function in sql server?

1113

Name and describe few console utilities for ssrs?

288

Explain what is sql server english query?

1109

What is the difference between function and stored procedure in sql server?

1153

What is the significance of master, tempdb and model databases?

1128

How to change a login name in ms sql server?

1133

What is dbcc command in sql server?

1150

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1059

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

1002

What are the kinds of subquery?

1071

Do you know the capabilities of cursors?

1217

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

1107

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1057

What are the components of sql server service broker?

1061

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