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?

1071

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

1036

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

995

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

1050

What are sparse columns?

1008

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

975

What does the on delete cascade option do?

1014

How are the unique and primary key constraints different?

1071

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?

1096

How to find tables without indexes?

1086

What is a collation?

1086

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

1072

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?

1263

Un-Answered Questions { SQL Server }

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1908

can an automatic recovery be initiated by a user? : Sql server administration

947

How to configure and test odbc dsn settings?

1155

can a database be shrunk with users active? : Sql server administration

1003

Do you know what is openxml in sql server?

1064

List the data types available in mssql?

1028

What is the importance of three tier architecture?

1084

What is trace flag in sql server?

1016

What are the mathematical functions supported by sql server 2005?

1063

What are sql azure firewall rules?

106

What are the advantages of using cte?

1008

What is dbcc command in sql server?

1087

What is stored procedures?

1025

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

972

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

988

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