What is database replication? What are the different types of replication you can set up in sql server?

0 Answers  

---

How do you check sql server is up and running?

0 Answers  

---

Explain the properties of sub-query in sql server?

0 Answers  

---

What is a primary key?

0 Answers  

---

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 Answers  

---

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

0 Answers   Cognizant,

---

Explain SELF JOIN ?

3 Answers   ADP,

---

What is the difference between a local and a global temporary table?

0 Answers  

---

What is the appropriate number of test cases that you can write on a database?

2 Answers   Microsoft,

---

how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 Answers  

---

What is check constraint in sql server?

0 Answers  

---

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  

---