How Clustered Index and Non clustered index stored on SQL
server?
Answers were Sorted based on User's Feedback
Answer / anitha
clustered index that reorders the way in which records in
the table are physically stored.
non clustered index in which the logical order of the index
| Is This Answer Correct ? | 14 Yes | 2 No |
Answer / 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 |
What is an iHTTPModule, and explain its implementation with its limitations?
Can the validation be done in the server side? Or this can be done only in the Client side?
What is .NetFramework?
What is the significance of ASP.NET routing?
What is a DLL Hell Problem in .Net?
Define reflection in .net?
How do you use a custom validator? When might you want to use one?
hi .net gurus. plz if any one has dumps on 70-631 and 70-541 on windows sharepoint services kindly mail me.
How do you do validations. Whether client-side or server-side validations are better ?
2 Answers InfoLinks, Microsoft,
How can we secure the data which is send from client side to server? Like the login id and paasword needs to be authenticated on the server but we cannot send it in plain text into the server.One more thing we are not using the SSL here.
What is MVVM in dot net?
When using the Pager object, inorder to know which page to go, which property you have to set to grid?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)