Skip to content
Episode 168 - New data types in SQL Server and a question about index fragmentation episode artwork

Oct 14, 2024 32 min

Episode 168 - New data types in SQL Server and a question about index fragmentation

from SQL Server Radio Hosted by SQL Server Radio

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: microsoft-dbas-club/Indexes/Table and Index High Unused Space.sql at MadeiraData/microsoft-dbas-club Check Index Fragmentation Based on Page Fullness and Fill Factor Upcoming webinar at the Cloud Data Driven Meetup: Database DevOps for Leaders - Eitan Blumin, Thu, Oct 24, 2024, 12:00 PM | Meetup

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Episode 168 - New data types in SQL Server and a question about index fragmentation

0:00 32:49

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of SQL Server Radio?

This episode is 32 minutes long.

When was this SQL Server Radio episode published?

This episode was published on October 14, 2024.

Can I download this SQL Server Radio episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.