SQL Server Interview Questions
Questions Answers Views Company eMail

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

Tech Mahindra,

6 5944

whats new about truncate in sql server 2008?

Serco, MedSave Healthcare,

1325

ow to bring suspect mode datbase online from scratch

700




1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

795

wat new abt truncate in sql server

HP, HCL,

2 3902

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

Microsoft,

796

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

Microsoft,

854

which backup strategy you are following at ur company

1009




your distribution database is full what will u do

968

Differences between logshipping and mirroring

Syntel, Microsoft,

1 3297

tell me the disaster recovery plan

Microsoft,

1299

application server is slow what may be the problem

Microsoft,

1095

Define the term DML, DDL and DTL?

1 22194

Creating Tables Using SELECT

1 1704

How can I create a table from another table without copying any values from the old table?

3 2902


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

how to take backup bcp out for a column in table in sql server?

865


what are the Prerequisites for Replication?

8515


How you trouble shoot when any job fails

701


Scalability, Availability, Integration with internet, etc.)?

1660


What is data modeling and Reterminal integrity?

682






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

1357


where the connection string store in the database

832


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

890


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

689


your distribution database is full what will u do

968


what is isolation level at dead lock?

1021


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1275


whats the maximum size of view state??

964


How much memory that we are using in Logshipping Concept?

724


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1158