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,133 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,650 reads

Blogs

T-SQL Tuesday #180: Good enough is perfect

By

How can you achieve good enough without compromising the process/product? In the world of...

How to Convert FileTime to DateTime

By

One of my customers recently wanted to rename each of the SQL audit files...

The pros and cons of self-service BI: What every industry leader should know

By

The post The pros and cons of self-service BI: What every industry leader should...

Read the latest Blogs

Forums

How to use a date range to open up a report?

By NineIron

The report that I want to open has an "ExamDate". I am trying to...

SQL estate future planning

By goodtimecharlie

Morning all, I've inherited a small (on prem) SQL estate.  I'm a DBA, used...

Error sub query return more than one value

By reza.asali

insert into NewKms8081..members SELECT (select u2.Id from SecurityKms8081..users u2 join SecurityKms8081..Import_users_barghGharb i2 on i2.code_personeli=u2.PersonnelNumber...

Visit the forum

Question of the Day

Cloud Sources for the Data Migration Assistant

Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)

See possible answers