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?


7 11953

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


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?


What is Lock table in SQL?


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


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


what is the sql equivaent of the dataset relation object ?


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?


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


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


How to restore performance issues and how to check?


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


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


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.


Issues related in upgrading SQL Server 2000 to 2005 / 2008


ow to bring suspect mode datbase online from scratch


Working with TLogs