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? 

SQL Server Performance Tuning

This post keeps complete best practices of database and query performance tuning dashboard and optimization techniques tips and tricks with examples. Detail discussion of how to improve SQL server 2008, 2012 and 2014 performance