Reuben Anderson

My feedback

  1. 29 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Reuben Anderson commented  · 

    "Maybe that says more about Slow Query Execution overall?"

    Huh?

    Executing the same query without the b-tree index is dramatically faster. That means the query optimizer is making the wrong choice.

    My scenario;

    - clustered columnstore index for general, large batch queries
    - nonclustered index covering a specific query

    - the nc index severely damages the performance of other queries.

    The cost estimation is wrong. There's no reason I can see why it should necessarily pick the nc index if the query is so much quicker when the nc index isn't there at all.

    An error occurred while saving the comment
    Reuben Anderson commented  · 

    Phew. Not just me.

    Reuben Anderson supported this idea  · 
  2. 24 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Azure Analysis Services  ·  Flag idea as inappropriate…  ·  Admin →
    Reuben Anderson supported this idea  · 
  3. 28 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Azure Analysis Services  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Reuben Anderson commented  · 

    Can I supplement this with - support service principal authentication to access data from Azure Sql Database / Azure Sql Datawarehouse

    Basically I need to set a managed identity on the datasource connection, with role based access in my Azure Sql db.

    Is this the effectively same issue or distinct?

    Reuben Anderson supported this idea  · 
  4. 395 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    57 comments  ·  Lab Services  ·  Flag idea as inappropriate…  ·  Admin →
    Reuben Anderson supported this idea  · 

Feedback and Knowledge Base