Answer / Monish Kumar

Scheduled Jobs or Scheduled Tasks in SQL Server refer to recurring, automated tasks that can be set up to run certain SQL Server Agent jobs at specific times. This can include database backups, script execution, and more.

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

7 Answers   Microsoft,

---

what is package and it uses and how can u call a package

1 Answers   Satyam,

---

What is difference between order by and group by?

1 Answers  

---

Can group functions be mixed with non-group selection fields in ms sql server?

1 Answers  

---

Explain the dirty pages?

1 Answers  

---

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

1 Answers  

---

What is role playing dimension with two examples? : sql server analysis services, ssas

1 Answers  

---

Can the “if update (colname)” statement be used in a delete trigger?

1 Answers  

---

Explain the properties of sub-query in sql server?

1 Answers  

---

Tell me what is the stuff and how does it differ from the replace function?

1 Answers  

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1 Answers  

---