Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

0 Answers  

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

0 Answers  

---

What extended events?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

What is bcnf normalization form?

0 Answers  

---

What do you understand by the denormalisation?

0 Answers  

---

What is the datatype returned by count(*)

22 Answers   247Customer, Asian CERC,

---

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

---

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

---

Explain user defined views?

0 Answers  

---