The first thing you need to understand about SQL Server is indexes. Â Somehow, some of the basic questions are often overlooked. They aren’t get asked or not much has answered it in forums. In this post, we’ll share some of the indexing questions we are shy to ask but often an integral part in understanding SQL Server.
Why can’t a table have two clustered indexes?
There are a lot of benefits in clustered tables, so why bother with heaps?
How do I override the fill factor when creating an index?
Can you crate a clustered index on a column with duplicate values?
Read the rest of the article here:Â https://www.simple-talk.com/sql/performance/sql-server-indexing-questions-we-were-too-shy-to-ask/