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 4148

What is BCP? When do we use it?

2 7956

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

3 5940

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

2 5790

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

3 10890

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

3 11428

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

Descon, Digital Domain,

4 23508

What is database normalization?


7 11719

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


5 12305

What is a trigger?

7 4143

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 9364

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

1 4023

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

2 7958

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

3 8961

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

5 33560

Post New SQL Server Questions

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?


wat wil hapn if we give the both read and deny read permission to user?


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do


If the job running very slow what is the action you do


whats new about truncate in sql server 2008?


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A


plss anybody specify tha constrian management system in dbms


What is best institute to Learn DotNET And SQL in chennai?


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


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?


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


What is data modeling and Reterminal integrity?


Call by value and call by reference in procedure and function, with NOCOPY.


how can u get last observation in an unknown dataset ?


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