How to delete existing rows in a table?

0 Answers  

---

Does full backup break log chain?

0 Answers  

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

---

What is the difference between the application object and session object?

0 Answers  

---

What is the difference between push and pull subscription? : sql server replication

0 Answers  

---

How many primary keys are possible in a table?

0 Answers  

---

How to see existing views in ms sql server?

0 Answers  

---

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

0 Answers   CSC, IBM,

---

Can one drop a column from a table?

0 Answers  

---

What is the sql case statement used for?

0 Answers  

---

How can you ensure that the database and sql server based application perform well?

0 Answers  

---

How to create a trigger for insert only?

0 Answers  

---