Episode 168 - New data types in SQL Server and a question about index fragmentation
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.
Add to basket failed.
Please try again later
Add to Wish List failed.
Please try again later
Remove from Wish List failed.
Please try again later
Follow podcast failed
Unfollow podcast failed
Episode 168 - New data types in SQL Server and a question about index fragmentation
-
Narrated by:
-
By:
About this listen
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
What listeners say about Episode 168 - New data types in SQL Server and a question about index fragmentation
Average Customer RatingsReviews - Please select the tabs below to change the source of reviews.
In the spirit of reconciliation, Audible acknowledges the Traditional Custodians of country throughout Australia and their connections to land, sea and community. We pay our respect to their elders past and present and extend that respect to all Aboriginal and Torres Strait Islander peoples today.