Difference b/w Clustered & non-clustered index? Not the
bookish definition, but how they internally works in SQL Server?
Answer / anand vanam
•In clustered Index leaf node contains the actual data pages
where as in Non clustered index leaf node contains index
pages.
•You can have only one clustered index per table but you can
have 249 Non clustered indexes per table as per SQL 2005
(999 in SQL 2008)
•The row locator in clustered index is the Clustered Index
Key where as in Non clustered index row locator is a pointer
to the row.
| Is This Answer Correct ? | 10 Yes | 1 No |
What are the character string functions supported by sql server 2005?
What is DAC? what is the use of it?
What is ms sql server reporting services?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
Explain aggregate functions?
What are the steps you must follow to hide sql server instances?
Is it possible to create tables in stored procedures using a variable for the table name?
What is the openxml statement in sql server?
What the class forname () does?
Delete duplicate rows without using rowid.
What is standby servers? Explain types of standby servers.
How to list all user names in a database?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)