Answer Posted / indira gandhi

1.check th disc space u have to use
2.check the profile client have any job,and query problem
3.use update_satistics to update indexes

-------------------------
to avoid the deadlock

use nolock command in select staement

What do you understand by SQL*Net?

1045

---

How to define and use table alias names in ms sql server?

1150

---

How do I create a stored procedure in dbml?

1021

---

What is inline variable assignment?

1039

---

What are the rules to use the rowguidcol property to define a globally unique identifier column?

1034

---

What is the purpose of update statistics and scope_identity() function?

1112

---

What are the authentication modes in sql server? How can it be changed?

1140

---

What are the system database in sql server 2005?

1055

---

How to write a query with a right outer join in ms sql server?

926

---

What is the security model used in sql server 2005?

1023

---

What is key set driven?

967

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1167

---

What is the difference between insensitive and scroll cursor?

1176

---

Do you know sql server 2008 backup compression?

977

---

What stored by the msdb? : sql server database administration

1016

---