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
•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|
on line cluster can we make if yes tell me the procedure
Difference between writing SQL query and stored procedure ?
What is a Join in SQL Server?
what is curser.
Which system tables contain information on privileges granted and privileges obtained
How cand Optimize SQL Server Stored Procedures
What are sub-queries? Give example? In which case sub-queries are not feasible?
how to connect sybase to sql server 2005?.
i need some interview questions on sql server developer plz any onee send some links.
What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?
What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?
What value could be assigned to Varchar Type?