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 number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

0 Answers  

---

What are distinctive joins find as a part of sql?

0 Answers  

---

How do you create a clustered index?

0 Answers  

---

What is data compression? : sql server database administration

0 Answers  

---

---

What is meant by indexing files?

0 Answers  

---

Where do you think the users names and passwords will be stored in sql server?

4 Answers   BirlaSoft,

---

Explain few examples of stored procedure over triggers?

0 Answers   ADITI,

---

Do you know sql server 2008 introduces automatic auditing?

0 Answers  

---

What are locks in sql?

0 Answers  

---

Do you know what is replace and stuff function in sql server?

0 Answers  

---

what is an index? : Sql server database administration

0 Answers  

---