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
16,688 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
15,555 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
13,164 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
15,057 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
15,557 reads
Blogs
Building a Docker image with Docker Build Cloud
In a previous blog post we went through how to build a Docker container...
Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
Going to Cloud? Look at the Shared Responsibility Model
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
Forums
SQL server native CDC
Have anyone implemented CDC, and if so, what has been your experience with it?...
Import and Export wizard stuck on Guest user
I'm getting a error when using the Import and Export wizard to copy tables...
Aligning Compatibility Version Strategy
I have joined a new project, where the business uses Azure SQL Hyperscale for...
Question of the Day
Initial Config of tempdb
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers