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  

---

What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,

---

what is call by value & call by reference ?

2 Answers   Cap Gemini,

---

What is the log shipping?

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,

---

What are the events recorded in a transaction log?

0 Answers  

---

How to modify an existing stored procedure in ms sql server?

0 Answers  

---

what is the system function to get current user's user id? : Sql server database administration

0 Answers  

---

what is the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

0 Answers  

---

What are various aggregate functions that are available?

0 Answers  

---

What is a transactions?

0 Answers  

---