Answer Posted / div

Cluster index directly represents the physically stored
data. So their order will be the same as and when they are
populated into the table. Accessing this data will be
faster.

Non-cluster index just provides a pointer to the data.
Accessing this data will be slower when compared to the
clustered data.

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2071

---

What do you mean by an execution plan? Why is it used?

1024

---

List out what other servers you can use with ssrs?

139

---

Can I delete event logs?

924

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1139

---

Explain about the command-line tool SQLCMD?

1086

---

What is the new security features added in sql server 2014? : sql server security

998

---

How to get the definition of a stored procedure back?

977

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

990

---

Can I work with several databases simultaneously? : sql server management studio

988

---

What is the purpose of floor function?

1039

---

What is a partition function in sql server?

1133

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1004

---

What is a field name?

964

---

what is bit datatype? : Sql server database administration

916

---