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 does Master database contains?

0 Answers   Abacus,

---

What is the purpose of floor function?

0 Answers  

---

Define indexes?

0 Answers  

---

whats new about truncate in sql server 2008?

0 Answers   MedSave Healthcare, Serco,

---

Difference between LEN() and DATALENGTH() in sql server ?

0 Answers   HCL,

---

How do you delete a data source?

0 Answers  

---

What are views in ms sql server?

0 Answers  

---

What is difference between unique and primary key?

0 Answers  

---

What is extent? Types of extents?

0 Answers  

---

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 Answers  

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---