Answer Posted / santhoshkumar.k

store procedure takes less time to execute the statement
than functions, also we can create loops inside the store
procedure.

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

2534

---

How to access the inserted record of an event?

1107

---

What is the purpose of the master database?

1198

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1050

---

Explain table valued parameters in sql server? Why tvp used?

1067

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

1045

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1329

---

What is database black box testing?

1072

---

Can sql server 2016 run on windows 7?

965

---

What is a field name?

1017

---

Explain different backup plans?

1005

---

What is sql collation?

1269

---

Where sql server user names and passwords are stored in sql server? : sql server database administration

1102

---

what are the different stages of Report Processing?

141

---

Explain the use of containers in ssis?

1013

---