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.

You rated this post out of 5. Change rating

2011-08-24

15,249 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)

You rated this post out of 5. Change rating

2011-08-03

15,777 reads

Blogs

T-SQL Tuesday #191 Round Up

By

I hosted this month, late as it turns out, but we still had a...

Come See Me at the PASS Data Community Summit

By

I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...

SQL Clone at Scale with Striped Backups

By

I had a customer recently reach out to ask if SQL Clone would work...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Managing unused indexes

By JasonO

While doing some housekeeping activity on several old but large production databases, I come...

Cloud Performance Considerations

By MichaelT

How important to SQL Server is the speed of the SSD and network latency?...

Visit the forum

Question of the Day

Striped Backup File Limits

In SQL Server 2022, how many backup files can I have in a striped backup?

See possible answers