Answer Posted / rahul

A) Creating a clustered index on a table re-arranges the data in a sequential manner. while creating clustered index, certain guidelines must be followed. They are:

1) Queries should return a range of values by using operators such as, BETWEEN, > , >= , < and <=.

B) Non-clustered index is created on a table, the data is not physically re-arranged in sequential order.

query processing

2102

---

What are binary string data types in ms sql server?

1172

---

How to connect to a sql server using odbc_connect()?

1094

---

What do you understand by replication in sql server?

995

---

What is cube dimension? : sql server analysis services, ssas

955

---

What are different types of raid configurations? : SQL Server Architecture

1003

---

What are the advantages of user-defined functions over stored procedures in sql server?

959

---

What is difference in performance between insert top (n) into table and using top with insert?

970

---

What should be the fill factor for indexes created on tables? : sql server database administration

1099

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

1062

---

Does a server store data?

864

---

What's new in sql management studio for sql server? : sql server management studio

995

---

What is temporal data type?

869

---

How to round a numeric value to a specific precision?

1011

---

Tell me what is fill factor?

907

---