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

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1030

what is the system function to get the current user's user id? : Sql server database administration

970

what's the maximum size of a row? : Sql server database administration

1033

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

981

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

934

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

913

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

897

what is database replicaion? : Sql server database administration

1124

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

861

what purpose does the model database serve? : Sql server database administration

936

what are constraints? Explain different types of constraints? : Sql server database administration

933

what is a schema in sql server 2005? : Sql server database administration

964

what are different types of raid configurations? : Sql server database administration

1008

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

978

how many clustered indexes can be created on a table? : Sql server database administration

1087

Un-Answered Questions { SQL Server }

Why can there be only one clustered index and not more than one?

949

Explain Geography datatype in SQL Server

1079

How you can minimize the deadlock situation?

992

Explain user defined functions?

955

What is the New in SQL server 2008?

933

What is scrollable cursor?

997

Explain transaction server auto commit?

1000

What is an inner join?

932

How to change the ownership of a schema in ms sql server?

1117

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

1009

What is meant by Active-Passive and Active-Active clustering setup?

1100

how you can deploy an ssrs report?

176

Explain about merge replications?

988

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2721

What is the main difference between ‘between’ and ‘in’ condition operators?

1129

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