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,

---

Explain an incremental backup?

0 Answers  

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers  

---

What is cross join in sql server joins?

0 Answers  

---

How to set a database state to offline in ms sql server?

0 Answers  

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---

How to handle error or exception in sql?

0 Answers  

---

What are distributed partitioned views?

0 Answers  

---

Explain fundamentals of Data ware housing & OLAP?

2 Answers  

---

How to run queries with sql server management studio express?

0 Answers  

---

What command would you use to create an index?

0 Answers  

---

What is replication with database mirroring? : sql server database administration

0 Answers  

---