Answer / 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.

Answer / monal

When you create Clustered Index data is physically sorted
based on the column used in clustered index.

don't know what is logical sort data.

What are the ways available in sql server to execute sql statements?

0 Answers  

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

3 Answers   HCL,

---

Distinguish between nested subquery and correlated subquery?

0 Answers  

---

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,

---

What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

---

Mention the command used to rename the database.

0 Answers  

---

What are the features of Embedded SQL

0 Answers   HCL,

---

what is diffrent between store procedure and trigger

2 Answers  

---

What is sql server 2000 work load governor?

0 Answers  

---

How to update multiple rows with one update statement in ms sql server?

0 Answers  

---

How to use "begin ... End" statement structures in ms sql server?

0 Answers  

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---