Answer Posted / rajesh b patil

As it is explained in the Answer #1, The Clustered Index
uses the Physical Sorting, just like the Page Index at the
Beginning of your book, but The Logical sorting means it
will be done with the Non Clustered Indices, as you all know
the data in the server stored on the multi page files,
because the amount of data stored on the database is huge,
So in case of the logical sorting depending upon say query
results the records are at your disposal which you have got
after filtering using a where clause, then the data is
coming from different pages and there is no continuation
like SNO column in case case of select *, So the pages where
the desired data is found are actually will hold the
references, means the record say #3, from page #3, will hold
the address of the Previous record address as well as the
next record address just like your Double Linked List Nodes,
I hope now logical sorting is explained by me here.

Can a database be shrunk with users active?

1133

---

What is built-in/administrator?

1005

---

Explain linked server in sql?

1219

---

In what sequence sql statement is processed?

1012

---

Introduction of rollup clause using sum and group by clause?

968

---

Explain the various types of concurrency problem?

1193

---

What is snapshot parameter in ssrs?

150

---

What is the difference between char, varchar and nvarchar?

1024

---

What are the database roles? : sql server security

1188

---

Explain what is the main purpose of having conversation group?

939

---

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1194

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

984

---

How to use subqueries in the from clause in ms sql server?

1162

---

How to delete existing rows in a table?

1160

---

What are transactions and its controls?

1061

---