Answer Posted / vikram
Clustered index hold data at the leaf node.
non clustered hold data location (pointer) at the leaf node.
when we create primary key Clustered index automatically
created
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What are advantages of ssrs or why we should use ssrs?
How except clause is differs from not in clause?
What is the default Port No on which SQL Server listens?
What are system databases into sql server (2005/2008) : sql server database administration
What method is used by the Command classes to execute SQL statements that return single values?
Explain error and transaction handling in sql server?
What is the difference between TRUNCATE and DROP?
What is executereader?
What does the not null constraint do?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
How to trouble shoot if unable to connect SQL Server
What is PROJECTION Operation?
How can sql server instances be hidden? : sql server security
Is INSTEAD OF trigger directly applicable to Table ?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
