Interested to Buy Any Domain ? << Click Here >> for more details...
How Clustered Index and Non clustered index stored on SQL
server?
- 2 Answers
- 8529 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / answerme
Clustered Index are always stored on disk in a certain
order i.e, the data on disk may well be stored in order of
the Primary Key. So the data retreival is faster, when
queried based on Primary key.
non Clustered indexes are all the other indexes on a table,
that do not dictate the order that records are stored on
disk.A non Clustered index stores all the fields that
comprise the index, plus a link to the actual full record
on disk. This link is the primary key (clustered index), so
in fact a non clustered index contains all the columns that
you specify for them plus the clustered index columns too.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How many types of triggers are there in update panel?
Explain server side state management system.
In a page I have gridview with options of select and delete using hyperlink when I am selecting any one of then it has to open another page how can it?
Explain method to handle error using HttpError in Web API?
About CLR, reflection and assemblies?
Explain the significance of routing? : asp.net mvc
What are ASP.NET Web Forms? How is this technology different than what is available though ASP?
I am trying to implement sorting facility from client side code in GridView Control. So how can I fill up an Array inside client side code (using JavaScript), i want to assign my DataSet object declared and filled up on Server side(in code behind) to the array (on client side)
What is the significance of ASP.NET routing?
Can we handle the error and redirect to some pages using web.config?
Why is it preferred to not use finalize for clean up?
What is slidemaster?
List the types of authentication supported by asp.net?
I have an excel file with data, i am importing this excel file data into Sqlserver 2005 database. while importing i am getting wrong data(ie, special characters) in one column(description column), upto some limit the data in that column is coming fine,after that data is coming like below. The "Walter" leather storage bench is one of our most popular styles. The top with the tufting and double stitching finish a very impressive piece. The size is perfect in front of beds and the storage adds another functional bonus. Open it up and sneak al���Ƴ�Â��ƴ�Ã��ƶ�Å�� al���Ƴ�Â��ƴ�Ã��ƶ�Å�� Is there anywhy to resolve this? (I am using recordset in coding for developing import process.) please help me soon.
What does session_start () do?
