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:
- 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
المعلومات
- البرنامج
- معدل البثيتم التحديث شهريًا
- تاريخ النشر١١ ربيع الآخر ١٤٤٦ هـ في ١٢:٠٠ م UTC
- مدة الحلقة٣٣ من الدقائق
- الحلقة١٦٨
- التقييمملائم