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,416 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,664 reads

Blogs

Getting Up and Running with Dapr

By

I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...

Data Platform products for Microsoft gaps

By

Microsoft has a ton of data platform-related products, but there are certain areas where...

Accessibility in font choice

By

Choosing the right typeface for your presentation (or for that matter anything you create...

Read the latest Blogs

Forums

Script to find session running SQL text and kill session

By caz100

Hi Looking for a  SQL script I can run as an agent job that...

Import Multiple Packages to SSIS server

By sagarSQLDBA

Comments posted to this topic are about the item Import Multiple Packages to SSIS...

need help on query

By abhas

Hi all, need help on below requirement. Thanks, Abhas

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers