What is checkpoint process in the 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  

---

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 Answers  

---

What are the types of user defined functions in sql server?

0 Answers  

---

Do you know the different ddl commands in sql?

0 Answers  

---

---

What are the types of indexing?

0 Answers  

---

How do I open a .db file?

0 Answers  

---

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 Answers  

---

Tell me extended events in sql server 2008?

0 Answers  

---

What does it mean to normalize a database and why would you do it?

0 Answers  

---

How many levels of sp nesting is possible?

0 Answers  

---

How to delete multiple rows with one delete statement in ms sql server?

0 Answers  

---