SQL Server Indexing Questions We Are Shy To Ask

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?

 

And more…

Read the rest of the article here: https://www.simple-talk.com/sql/performance/sql-server-indexing-questions-we-were-too-shy-to-ask/

 

Leave a Reply

Your email address will not be published. Required fields are marked *