{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Programming Tech Brief By HackerNoon","title":"Vector Data Types & Native Indexing: The ANN Revolution We Didn’t Know We Needed","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/e7e214a5\"></iframe>","width":"100%","height":180,"duration":543,"description":"\n        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.\nVector indexes in SQL Server: maintenance & tuning\nCheck more stories related to programming at: https://hackernoon.com/c/programming.\n            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.\nThis story was written by: @arvindtoorpu. Learn more about this writer by checking @arvindtoorpu's about page,\n            and for more stories, please visit hackernoon.com.\nNative 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.\n        \n        ","thumbnail_url":"https://img.transistorcdn.com/KhCapPSRkLGL2Xw8888yuChkNRWthaKapLYTvNdu4W4/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzQxMTY2LzE2ODM1/ODIzMzAtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}