SQL Server Education (by the geeks, for the geeks)
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 …
sql_server_covering_index_2: Adding Non Key Columns Read MoreHi 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 …
SQL Server Covering Index 1 Read MoreHi 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 …
SQL Server – Does an Index B-Tree structure always have a root page? Read MoreHi 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, …
SQL Server: Indexing for Aggregates in SQL Server Read MoreHi 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 …
SQL Server Filtered Indexes Read More