Jan 4, 2015

How Table | Database | data are physically stored in Sql server

This post discuss about how databases, tables, indexes and data are physically stored in disk in sql server (anatomy).

Dec 28, 2014

Which one is better clustered index or non-clustered index in Sql server?

One of the colleagues asked me question which one is better clustered index or non-clustered index in Sql server?