Episode 168 - New data types in SQL Server and a question about index fragmentation
- Author
- SQL Server Radio
- Published
- Mon 14 Oct 2024
- Episode Link
- http://sqlserverradio.com/episode-168-new-data-types-in-sql-server-and-a-question-about-index-fragmentation
Guy and Eitan discuss some interesting news from Microsoft regarding SQL Server, and also about the right way to handle index fragmentation.
Relevant links:
- Resources from Microsoft:
- Preview release of SDK-style SQL projects in Visual Studio 2022 - Microsoft Community Hub
- Native JSON support now in preview in Azure SQL Managed Instance - Microsoft Community Hub
- EAP for Vector Support Refresh - Introducing Vector type - Azure SQL Devs’ Corner (microsoft.com)
- Calling external REST endpoints from Azure SQL Database | Microsoft Learn
- Index fragmentation:
- SQL Server Backup, Integrity Check, Index and Statistics Maintenance (hallengren.com)
- Should we do index maintenance on an Azure SQL Managed Instance or Azure SQL Database? (kendralittle.com)
- Stop Worrying About SQL Server Index Fragmentation (brentozar.com)
- Why SQL Server Index Fragmentation Isn’t A Problem On Modern Storage Hardware – Darling Data (erikdarling.com)
- Index fragmentation scripts:
- Upcoming webinar at the Cloud Data Driven Meetup:
