Answer / Mithilesh Mishra

XML data type in SQL Server is a built-in data type that allows you to store, manipulate, and query XML data within tables. It enables seamless integration of structured data from the relational world with unstructured data from the XML world.

What is the function of inner join?

1 Answers  

---

If no size is defined while creating the database, what size will the database have?

1 Answers  

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

Difference between 2NF &3NF ?

1 Answers   Cap Gemini,

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1 Answers  

---

Is truncate a dml command?

1 Answers  

---

About DTS usage ?

2 Answers   Cognizant, Wipro,

---

how can you attach more than 20 ldf files in sql server

1 Answers   IBM,

---

Do you know how to make remote connection in database?

1 Answers  

---

What is the contrast between sql and mysql?

1 Answers  

---

How to configure and test odbc dsn settings?

1 Answers  

---