Skip to content
Prodata

Prodata

SQL Centre Of Excellence

  • Home
  • Services
    • Synapse and EDW
    • SSAS Services
    • Power BI
    • SQL Server Platform
  • Blogs
  • Offerings
  • About Us
    • History and Verticals
    • Team
    • Contact
    • Jobs at Prodata

Category: SQL Server

SQL Server, Uncategorized

Do we need to maintain Columnstores in SQL Pools ?

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 ?

August 28, 2021August 28, 2021SQL, SqlPool, SyanpseLeave a comment
SQL Server

Cannot Start PolyBase Services

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

February 22, 2017January 12, 2021SQLLeave a comment

Posts navigation

Older posts
Newer posts
  • Facebook
  • Twitter
  • LinkedIn
Prodata
Proudly powered by WordPress Theme: Shoreditch.