sql_server_covering_index_2: Adding Non Key Columns
Hi Friends, This blog is the continuation of my previous blog on Use of Covering Indexes here is the link… Today here I will explain Adding non key columns in the …
Read MoreTag: SQL Server indexes
SQL Server Covering Index 1
Hi Friends, Today, here I just want to explain ‘what is SQL Server Covering Index?’ as well as ‘why we use Covering Indexes?’ What is Covering Index? “Covering Index is a …
Read MoreSQL Server – Does an Index B-Tree structure always have a root page?
Hi Friends, This is a common question I face in many of my classes and consulting assignments? The answer is NO. Indexes are B-Tree structures (balanced tree) where navigation/searching happens from …
Read MoreSQL Server: Indexing for Aggregates in SQL Server
Hi Friends, Here is a query and I want to create the right indexes for it. Let us do things step by step: (I am using AdventureWorks2008 for this) SELECT SOH.CustomerID, …
Read MoreSQL Server Filtered Indexes
Hi Friends, SQL Server Filtered indexes use a filter predicate to index a portion of the table, a well-defined subset of data. They can be considered to be an optimized alternative …
Read More