What is an active database?

0 Answers   HCL,

---

What structure can you implement for the database to speed up table reads?

0 Answers  

---

What is a transact-sql statement batch in ms sql server?

0 Answers  

---

What do you understand by mirroring?

0 Answers  

---

how we can store the value like that 001,003,023 etc in sql server 2005

7 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  

---

Explain left outer join and right outer join?

0 Answers  

---

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

---

Tell me what is de-normalization and what are some of the examples of it?

0 Answers  

---

How to declare and use cursor variables?

0 Answers  

---

How many triggers are possible per table?

0 Answers  

---

How will you monitor replication latency in transactional replication? : sql server replication

0 Answers  

---