Explain what is dbcc?

0 Answers  

---

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

What do you understand by triggers and mention the different types of it?

0 Answers  

---

What is cube dimension? : sql server analysis services, ssas

0 Answers  

---

What is Left Outer Join?

2 Answers  

---

---

What are number line correlation administrators will use while working with a subquery?

0 Answers  

---

How to count the number of duplicate items in a table?

3 Answers  

---

What is the process of normalization?

0 Answers  

---

How do you set a trace flag in sql server?

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 use order by with union operators in ms sql server?

0 Answers  

---

What happens if null values are involved in datetime operations?

0 Answers  

---