This is the third blog in a series looking at the need for DW Automation focusing on Synapse SQL Pools (dedicated). In the first blog we looked at why we need DW Automation tools and what they look like:https://prodata.ie/2021/09/14/the-need-for-dw-automation-1-3/In the second blog we looked at a maturity model for DW automation with six levels of … Continue reading DW Automation demo for Synapse SQL Pools (3/3)
Tag: SQL
TLDR The short answer is YES - if you have >= 60 million rows, then a poorly maintained column store was 100% slower due to trim fragmentation and 64% slower due to the delta row store with some updates in our tests. Obviously this is just a small test on only 60 million rows and … Continue reading Do we need to maintain Columnstores in SQL Pools ?