What is the difference between dbcc indexdefrag and dbcc reindex?

0 Answers  

---

What are the types of stored procedures in an sql server?

0 Answers  

---

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

1 Answers   RBS,

---

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,

---

How to apply cascading referential integrity in place of triggers?

0 Answers  

---

how would you improve etl (extract, transform, load) throughput?

0 Answers   LinkedIn,

---

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,

---

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  

---

event classes in sql server

2 Answers   Accenture, AFE,

---

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

0 Answers  

---

What are scalar functions in sql?

0 Answers  

---

What are the components of dbms?

0 Answers  

---