Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

0 Answers  

---

what is physical sort data and logical sort data in index?

2 Answers  

---

diffrence between Cluster Index and non Cluster Index

3 Answers   Wipro,

---

How do I find the transaction log size in sql server?

0 Answers  

---

What is the disadvantages of index?

3 Answers   TCS,

---

Write a code to select distinct records without using the DISTINCT keyword.

0 Answers   Aspiring Minds,

---

What is a view and what are its advantages?

0 Answers  

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---

HOW TO RENAME A COLUMN NAME

3 Answers  

---

Which stored procedure will you be running to add a linked server?

1 Answers  

---

Explain what is “asynchronous” communication in sql server service broker?

0 Answers  

---