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 4401

What is BCP? When do we use it?

2 8126

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

3 6161




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

2 5975

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

3 11290

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

3 12009

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

Descon, Digital Domain,

4 24983

What is database normalization?

Digicel,

7 12054




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

eFunds,

5 12729

What is a trigger?

7 4425

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 10287

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

1 4393

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

2 8439

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

3 9582

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

5 34614


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what is the Ticketing tool used in Wipro technologies at Bangalore...???

5172


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

899


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

926


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

877


Which is the best place or learning center for MS SQL?????In Bangladesh?????

909






In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

845


Tell about MOM Tool(Microsoft Operator Manager)?

719


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

1384


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?

978


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1527


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

1194


whats the maximum size of view state??

985


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

975


your distribution database is full what will u do

993


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

866