what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

Can we take the full database backup in log shipping?

0 Answers  

---

What do you understand by coalesce in sql server?

0 Answers  

---

Describe in brief sql server monitoring ways.

0 Answers  

---

What do you mean by collation recursive stored procedure?

0 Answers  

---

optimization techinques

0 Answers   Wipro,

---

Suggest a method of joining two tables.

0 Answers   Ernst Young, Thomson Reuters,

---

Which tcp/ip port does the sql server run on? How can it be changed?

0 Answers  

---

What are the various Isolation levels?

2 Answers   HP,

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

0 Answers  

---

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

10 Answers   Cognizant, Infosys,

---

what is an index? : Sql server database administration

0 Answers  

---