how would you troubleshoot blocking? : Sql server database administration

0 Answers  

---

What is the use of custom fields in report?

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

How to remove duplicate rows from table?

0 Answers  

---

What is the order by used for?

0 Answers  

---

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

How to declare and use cursor variables?

0 Answers  

---

How to create a store procedure with encryption?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers  

---

What is difference between materialized view and view?

0 Answers  

---

What are 3 ways to get a count of the number of records in a table?

0 Answers  

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---