Answer / Kavi Raj Singh

{"Cluster Index": "A cluster index in SQL Server is a type of index that not only stores the data for the indexed column but also reorders the data in the table itself. The first field specified by the cluster key determines the physical order of the records in the table.","Non-Cluster Index": "On the other hand, Non-Cluster index (also known as a regular index) does not sort the records in the table. It only creates an additional structure containing the indexed column values along with pointers to the actual data rows."

What are relationships and mention different types of relationships in the dbms

1 Answers  

---

Explain the etl (extraction, transformation, and loading)?

1 Answers  

---

What are the extra roles available in msdb? : sql server security

1 Answers  

---

What is "scheduled jobs" or "scheduled tasks"?

1 Answers  

---

Explain filtered indexes?

1 Answers  

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

Using the customer, and order table in northwind database, please write a query to produce xml?

1 Answers  

---

What samples and sample databases are provided by microsoft?

1 Answers  

---

What is sql server profiler trace data file?

1 Answers  

---

What does it mean to be in union?

1 Answers  

---

What is the default Port No on which SQL Server listens?

1 Answers  

---

What is abstracting periodical?

1 Answers  

---