/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 www.red-gate.com
SQL Server Storage Internals 101 - Simple Talk
| | littlekendra.com
Where are key columns stored in a nonclustered index in SQL Server?
3.9 parsecs away

Travel
| | Kendra Little writes and draws comics about SQL Server, Data Platforms, and Database DevOps.
| | timilearning.com
Data Storage on Your Computer's Disk - Part 1
2.9 parsecs away

Travel
| | Have you ever wondered how data stored in databases actually gets represented on your computer's hard disk? Or why some queries to your database tables benefit from adding indexes on columns? Well, whether you have or not, here's a series of posts that aim to detail my understanding of the journey from inserting a row to a database table, to actually retrieving that row.
| | use-the-index-luke.com
Index INCLUDE Clause: How it works and when to use it
3.2 parsecs away

Travel
| | The INCLUDE clause for CREATE INDEX is available in some SQL databases: Microsoft SQL Server, PostgreSQL, and IBM Db2 (LUW)
| | www.ssp.sh
Data Lake Table Formats (Open Table Formats)
16.2 parsecs away

Travel
| Prominent table formats include Delta Lake, Apache Iceberg, and Apache Hudi.