Answer Posted / Dauji Garg

{"1": "Database design and development.
2. Database security and access control.
3. Performance tuning, monitoring, and troubleshooting.
4. Backup and recovery management.
5. Database migration and upgrades."}

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1134

---

Can you index views?

955

---

What is temporary table in sql server? Why we use temp table?

1023

---

When should you use an instead of trigger?

1054

---

Why and when do stored procedure recompile?

1064

---

List the ways in which dynamic sql can be executed?

1087

---

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8231

---

How to remove duplicate rows from table except one?

1090

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1024

---

Why we use the openxml clause?

1080

---

Why should you use or avoid select * statements?

1111

---

What are the kinds of subquery?

1109

---

What kind of problems occurs if we do not implement proper locking strategy?

1500

---

What are the different subsets of sql?

1654

---

How can I check that whether automatic statistic update is enabled or not?

1113

---