Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Azure SQL Database: Columnstore indexes | Azure Friday

Microsoft Azure
341K subscribers
<__slot-el>
<__slot-el>
9.9K views 2 years ago #Azure #Microsoft #AzureFriday
Davide Mauri is back with Lara Rubbelke to discuss columnstore indexes. In a typical relational database data is stored per row. This means that all row columns are saved together, which is great in all those cases where you want to retrieve all the information related to a specific row. But what if you want to have all the data stored in a subset of columns but for all the rows? That would be complex and slow—unless data was saved per-column instead of per-row. That's exactly what columnstore indexes in Azure SQL Database enables you to do. Chapters 00:00 – Introduction 01:00 – Columnstore overview 07:00 – Demo: index creation 10:14 – Demo: querying with columnstore 13:53 – Demo: batch mode with LAG operator 15:00 – Wrap-up Recommended resources ■ Columnstore indexes: Overview – https://aka.ms/azfr/724/01 ■ Azure SQL Database – https://aka.ms/azfr/724/02 ■ Niko Neugebauer on Columnstore – http://www.nikoport.com/columnstore/ ■ Create a Pay-as …...more
...more
Azure SQL Database: Columnstore indexes | Azure Friday
272Likes
9,968Views
2022Jul 29
Davide Mauri is back with Lara Rubbelke to discuss columnstore indexes. In a typical relational database data is stored per row. This means that all row columns are saved together, which is great in all those cases where you want to retrieve all the information related to a specific row. But what if you want to have all the data stored in a subset of columns but for all the rows? That would be complex and slow—unless data was saved per-column instead of per-row. That's exactly what columnstore indexes in Azure SQL Database enables you to do. Chapters 00:00 – Introduction 01:00 – Columnstore overview 07:00 – Demo: index creation 10:14 – Demo: querying with columnstore 13:53 – Demo: batch mode with LAG operator 15:00 – Wrap-up Recommended resources ■ Columnstore indexes: Overview – https://aka.ms/azfr/724/01 ■ Azure SQL Database – https://aka.ms/azfr/724/02 ■ Niko Neugebauer on Columnstore – http://www.nikoport.com/columnstore/ ■ Create a Pay-as-You-Go account (Azure) – https://aka.ms/azfr/724/payg ■ Create a free account (Azure) – https://aka.ms/azfr/724/free Connect with us ■ Lara Rubbelke | @SQLGal –   / sqlgal   ■ Davide Mauri | @MauriDB –   / mauridb   ■ Azure Friday | @AzureFriday –   / azurefriday   #Microsoft #Azure #AzureFriday #AzureSQL

Follow along using the transcript.

Microsoft Azure

341K subscribers