Explain the concepts and capabilities of sql server?

0 Answers  

---

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  

---

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

0 Answers  

---

Explain where clause?

0 Answers  

---

Do you know what is openxml in sql server?

0 Answers  

---

---

Mention the differences between substr and charindex in sql server.

0 Answers  

---

What is the datatype returned by count(*)

22 Answers   247Customer, Asian CERC,

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

0 Answers  

---

Explain the architecture of SQL Server?

2 Answers   ABC, HP, Oracle,

---

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

---

How to get a list of columns in a view using "sys.columns" in ms sql server?

0 Answers  

---

What is BLOCK statements in SQL?

0 Answers   HCL,

---