SQL Server Interview Questions
Questions Answers Views Company eMail

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 4289

What is BCP? When do we use it?

2 8081

What should we do to copy the tables, schema and views from one SQL Server to another?

3 6086




What are the different types of joins and what does each do?

2 5925

What is a sub-query? When would you use one?

3 11160

What are three SQL keywords used to change or set someone?s permissions?

3 11841

What is referential integrity? What are the advantages of it?

Descon, Digital Domain,

4 24580

What is database normalization?

Digicel,

7 11953




Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

eFunds,

5 12563

What is a trigger?

7 4327

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

Merrill Lynch, Wipro, Accenture,

2 10113

What is an execution plan? When would you use it? How would you view the execution plan?

1 4272

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 8301

What are the different types of replication? How are they used?

3 9418

What is the difference between a local and a global variable?

5 34311


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2677


What is Lock table in SQL?

267


can any body tell me how to know the password of current user in sql server

919


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1254


what is the sql equivaent of the dataset relation object ?

844






after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

949


How can we call UDF(User Define Function) using C# code in ASP.net ?

4679


how to use DTS package in 2000,2005,2008 in sql server

779


How to restore performance issues and how to check?

844


on line cluster can we make if yes tell me the procedure

837


what exactly sql injuction.how to overcome.....

1311


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.

1578


Issues related in upgrading SQL Server 2000 to 2005 / 2008

767


ow to bring suspect mode datbase online from scratch

685


Working with TLogs

683