Answer Posted / sasikala

one way to kill the process which is responsible for dead lock. after this the process can proceed without any problem. after a process completed , the killed process should be created and executed as if nothing has happened. but the killed process might have changed in an data base or some records. it must have changed as before to maintain the consistency.

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1924

---

What are the types of dml?

978

---

What is inline table-value user-defined function?

1105

---

What number sorts of privileges are accessible in sql?

1033

---

explain databases and sql server databases architecture? : Sql server database administration

957

---

What is difference between stored procedure and user defined function?

1100

---

Why use sub query in sql server and list out types of sub queries?

998

---

Explain the microsoft sql server delete command?

1017

---

Name 3 ways to get an accurate count of the number of records in a table?

1036

---

What is a file group?

1089

---

Explain microsoft sql server functions?

1107

---

What do I need to start working with sql studio? : sql server management studio

1110

---

How important do you consider cursors or while loops for a transactional database?

960

---

How do I manually uninstall an instance of sql server 2016?

1035

---

What types of replication are supported in sql server?

1063

---