Azure SQL Database Clustered Columnstore Index

Posted on August 6, 2019 by blobeater

You can read about columnstore indexes here (https://azure.microsoft.com/en-gb/blog/transforming-your-data-in-azure-sql-database-to-columnstore-format/). I won’t rehash the material but high level, these index types are optimized for analytical queries and high compression of data (up to 100x). This format is perfect for the large data sets that can be efficiently compressed using this format and analytical queries with complex calculations that use subset of the table columns.

Continue reading →

Azure SQL Database and Columnstore Indexes

Posted on April 9, 2018 by blobeater

I have come to understand the importance of using columnstore indexes when my queries are aggregating and scanning across many millions of rows.

Continue reading →

Azure SQL Database – Using sp_BlitzIndex

Posted on December 5, 2017 by blobeater

I was doing some normal activities on one of my Azure SQL Databases, I went to make a cup of tea and returned to the following message:

The statement has been terminated. Msg 40544, Level 17, State 12, Line 15 The database ‘TestDB’ has reached its size quota. Partition or delete data, drop indexes, or consult the documentation for possible resolutions.

Continue reading →

Azure SQL Database Resumable Online Index Rebuild

Posted on September 14, 2017 by blobeater

If you know me by now I like rebuilding indexes and that is no different in Azure. Now we have the ability to resume a paused rebuilding operation rather than cancelling it (Feature currently in public preview). I like this because I have the flexibility to pause it if I feel that it is taking up too much DTU (Database Transaction Unit) usage hence I can free up resources for other operations.

Continue reading →

Azure Robots – Index Performance Recommendation

Posted on June 1, 2017 by blobeater

They are watching me and my Azure SQL Database and recently I noticed a low impact performance recommendation was made. Naturally I became very interested. Within your database (when in the portal) under operations you may notice something similar to the below:

Continue reading →