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 ?
Category: SQL Server
One of my pet hates attending SQL talks is when the “expert” speaker spends most of the time blabbing on about “install” and “configuration” difficulties they had. It kinda paints a picture that they probably haven’t actually done much with the technology yet. Saying that I thought I would add some notes on problems starting … Continue reading Cannot Start PolyBase Services