David Durant


Stairway to SQL Server Indexes

Filtered Indexes in SQL Server: Stairway to SQL Server Indexes Level 7

A filtered index eliminates unusable entries from the index, producing an index that is as beneficial as, but much smaller than, an unfiltered index. If a certain subset of a table's data is frequently requested, a filtered index can also be a covering index; resulting in a considerable reduction in IO.

2011-08-24

14,197 reads

Stairway to SQL Server Indexes

Bookmarks in SQL Server Indexes: Stairway to SQL Server Indexes Level 6

A nonclustered index entry consists of search key columns, included columns, and the bookmark. The bookmark value will be either a RID or the clustered index's key, depending upon whether the table is a heap or a clustered index. Choosing the best clustered index for a table requires that you follow three guidelines to ensure that the index key will make a good bookmark.

3 (1)

2011-08-03

14,339 reads

Blogs

Top 10 Must-Ask Questions Before Going to the Cloud

By

After architecting and migrating some of the world’s largest data platforms, Let’s walk through my top...

Markdown Links– Remembering the Basics

By

For some reason, I can never remember how to do markdown links. I know...

Why Aren’t You Automating Database Deployments?

By

Building out processes and mechanisms for automated code deployments and testing can be quite...

Read the latest Blogs

Forums

B? túi bí quy?t ki?m ti?n t? Forex

By duyen96dn

th? tru?ng ngo?i h?i Forex là m?nh d?t d?u tu m? màu giúp các...

Run Azure Automation Runbook Against DB Hosted on an Azure VM

By dan-404057

Hi - has anyone created a PowerShell runbook which connects to a database hosted...

The Compression Type

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Compression Type

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers