{"podcast":{"title":"Programming Tech Brief By HackerNoon","slug":"programming-tech-brief-by-hackernoon-6364125","podcast_index_feed_id":6364125,"rss_url":"https://feeds.transistor.fm/programming-tech-brief-by-hackernoon","website_url":"https://hackernoon.com/c/programming","image_url":"https://img.transistorcdn.com/AKbQjnYbCNDgF_frZ_Hpi8tkLS7aZezqecpWn6o-Rh8/rs:fill:0:0:1/w:1400/h:1400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzQxMTY2LzE2ODM1/ODIzMzAtYXJ0d29y/ay5qcGc.jpg","author":"HackerNoon","episode_count":100,"summary":"Learn the latest programming updates in the tech world.","last_synced_at":"2026-07-29T06:19:42.842448+00:00","page_url":"https://stenobird.com/podcast/programming-tech-brief-by-hackernoon-6364125"},"episode":{"title":"Vector Data Types & Native Indexing: The ANN Revolution We Didn’t Know We Needed","slug":"vector-data-types-native-indexing-the-ann-revolution-we-didn-t-know-we-needed","published_at":"2026-07-14T16:01:42+00:00","page_url":"https://stenobird.com/podcast/programming-tech-brief-by-hackernoon-6364125/vector-data-types-native-indexing-the-ann-revolution-we-didn-t-know-we-needed","show_page_url":"https://stenobird.com/podcast/programming-tech-brief-by-hackernoon-6364125","url":"https://share.transistor.fm/s/e7e214a5","audio_url":"https://media.transistor.fm/e7e214a5/6e33f49b.mp3","summary":"This story was originally published on HackerNoon at: https://hackernoon.com/vector-data-types-and-native-indexing-the-ann-revolution-we-didnt-know-we-needed . Vector indexes in SQL Server: maintenance & tuning Check more stories related to programming at: https://hackernoon.com/c/programming . You can also check exclusive content about #rdbms , #sql-server , #vector-database , #vector-data-types , #native-indexing , #ann-revolution , #euclidean-distance , #text-embedding-ada-002 , and more. This story was written by: @arvindtoorpu . Learn more about this writer by checking @arvindtoorpu's about page, and for more stories, please visit hackernoon.com . Native vectors & ANN indexing enable fast similarity searches without external DBs. But they're storage-hungry (4x data size), need frequent rebuilds, and risk parameter sniffing. Tune memory grants, use OPTION(RECOMPILE), and monitor tempdb spills religiously.","meta_description":"This story was originally published on HackerNoon at: https://hackernoon.com/vector-data-types-and-native-indexing-the-ann-revolution-we-didnt-know-we-nee…","key_points":[],"chapters":[],"topics":[],"duration_seconds":543,"processing_state":"not_requested","actions":[{"name":"request_transcript","method":"POST","url":"https://stenobird.com/v1/public/podcasts/programming-tech-brief-by-hackernoon-6364125/episodes/vector-data-types-native-indexing-the-ann-revolution-we-didn-t-know-we-needed/transcription-requests","description":"Idempotently request low-priority transcript generation for this episode."},{"name":"read_markdown","method":"GET","url":"https://stenobird.com/podcast/programming-tech-brief-by-hackernoon-6364125/vector-data-types-native-indexing-the-ann-revolution-we-didn-t-know-we-needed.md","description":"Read the agent-friendly Markdown representation of this episode resource."}]}}