/explore
|
You are here 
|
www.sqlshack.com | ||
| | | | |
jack-vanlightly.com
My career in data started as a SQL Server performance specialist, which meant I was deep into the nuances of indexes, locking and blocking, execution plan analysis and query design. These days I'm more in the world of the open table format such as Apache Iceberg. Having learned the internals of both transactional and analytical database systems, I find the use of the word "index" interesting as they mean very different things to different systems. I see the term "index" used loosely when discussing open table format performance, both in their current designs and in speculation about future features that might make it into their specs. But what actually counts as an index in this world? Some formats, like Apache Hudi, do maintain record-level indexes such as,... |
|
| | | | | ||
| | | | |
stribny.name
A list of things that we can do when we need to scale a SQL database. |
|
| | | | | ||
| | | | |
curatedsql.com
[AI summary] A collection of SQL-related blog posts from January 4, 2024, discussing topics like data manipulation, database management, and SQL Server features. |
|
| | | | | ||
| | | | |
serverascode.com
A techno-blog for our techno-times |
|
| | | |||
