Index Internal Structure in SQL Server: Stairway to SQL Server Indexes Level 10
A detailed look the B-Tree structure – Leaf level and non-leaf level.
2012-01-20
15,518 reads
David Durant
Reading Query Plans: Stairway to SQL Server Indexes Level 9
Determining how, and if, SQL Server is using your indexes.
2011-10-05
14,783 reads
Unique Indexes in SQL Server: Stairway to SQL Server Indexes Level 8
Indexes that ensure data integrity in addition to locating rows.
2011-09-14
12,461 reads
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
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.
2011-08-03
14,664 reads
Blogs
Getting Up and Running with Dapr
By Steve Jones
I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...
Data Platform products for Microsoft gaps
By James Serra
Microsoft has a ton of data platform-related products, but there are certain areas where...
Accessibility in font choice
Choosing the right typeface for your presentation (or for that matter anything you create...
Forums
Script to find session running SQL text and kill session
Hi Looking for a SQL script I can run as an agent job that...
Import Multiple Packages to SSIS server
Comments posted to this topic are about the item Import Multiple Packages to SSIS...
Ask SSC