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

0 Answers   Cognizant,

---

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  

---

What do you mean by table and field in sql?

0 Answers  

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

Explain DBCC?

0 Answers   QuestPond,

---

---

If user is owning any SQL Objects, can we drop that user

0 Answers  

---

How to find which stored procedure is currently running in sql server?

0 Answers  

---

can any one please send sql quries most used in applications.

2 Answers  

---

How to locate and take substrings with charindex() and substring() functions?

0 Answers  

---

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

0 Answers  

---

Explain transaction server isolation?

0 Answers  

---

What is user stored procedure & it purpose?

4 Answers   Wipro,

---