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 4466

What is BCP? When do we use it?

2 8183

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

3 6232

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

2 6041

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

3 11406

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

3 12216

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

Descon, Digital Domain,

4 25312

What is database normalization?


7 12148

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


5 12809

What is a trigger?

7 4499

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 10447

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

1 4535

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

2 8573

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

3 9758

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

5 34902

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

Why do you want to join software field as you have done your BE in Electronics?


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)


query processing


How to restore performance issues and how to check?


How to trouble shoot if unable to connect SQL Server


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?


what is checksum in sql server.........???


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?


1 01 101 01010


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


whats the maximum size of view state??


What is the difference between online clustering and Offline clustering?


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you


How much memory that we are using in Logshipping Concept?