Answer / Nitin Yadav

{"distinctive joins": "SQL join types that allow for combining rows from two or more tables based on a related column","types": ["Inner Join", "Left Join", "Right Join", "Full Outer Join"]}

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

3 Answers   Apple,

---

What is data file in computer?

1 Answers  

---

What is transaction server auto commit?

1 Answers  

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1 Answers  

---

What is PROJECTION Operation?

1 Answers   Infosys,

---

How do you create a data source?

1 Answers  

---

What is catalog views?

1 Answers  

---

How to maintain a fill factor in existing indexes?

1 Answers  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1 Answers  

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1 Answers  

---

What is the difference between seek predicate and predicate?

1 Answers  

---