Answer Posted / awi (focus)

count(*) return Int Data Type

What are the two modes of authentication in sql server?

522

---

Tell me when is the update_statistics command used?

514

---

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

541

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

548

---

How are the exceptions handled in sql server programming?

611

---

---

What is nolock hint in sql server 2008

635

---

System requirements for sql server 2005 express edition?

569

---

How to modify existing triggers using "alter trigger"?

531

---

What is the cpu pressure?

565

---

How you can minimize the deadlock situation?

555

---

What is the data tier application?

145

---

How can I check if a view exists in a sql server database?

567

---

How network traffic be reduced by using the stored procedure?

586

---

What are diverse clauses that form a part of sql?

599

---

What are approximate numeric data types in ms sql server?

591

---