Difference between clustered and non-clustered index

Difference between clustered and non-clustered index.

Both stored as B-tree structure. The leaf level of a clustered index is the actual data where as leaf level of a non-clustered index is pointer to data. We can have only one clustered index in a table but we can have many non-clustered index in a table. Physical data in the table is sorted in the order of clustered index while not with the case of non-clustered data
Inline variable assignment in sql server 2008 - Sql server 2008
Inline variable assignment in SQL Server 2008 enables to – declare, and assign the variables in a ‘single line’..........
What is Compound Operators in sql server 2008? - Sql server 2008
Compound operators feature is enhanced in SQL Server 2008. They are like compound operators in languages like C, C++ etc..........
SQL Server 2008 introduces automatic auditing - Sql server 2008
Automatic auditing is a true auditing solution for enterprise customers. STL Trace can be used for satisfying several auditing needs..........
Post your comment