When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

---

How to loop through result set objects using odbc_fetch_row()?

0 Answers  

---

What do you mean by a dependent functionality in a build?

0 Answers   HCL,

---

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

---

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

0 Answers  

---

---

Determine when an index is appropriate?

0 Answers  

---

How to use column default values in insert statements in ms sql server?

0 Answers  

---

Explain what is meant by replication of database?

0 Answers   Cap Gemini,

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

What is difference between table aliases and column aliases? Do they affect performance?

0 Answers  

---

What the different components in replication and what is their use?

0 Answers  

---

Describe how to use linked server?

0 Answers  

---