Anonymous

My feedback

  1. 1 vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      0 comments  ·  Azure mobile app  ·  Flag idea as inappropriate…  ·  Admin →
      Anonymous shared this idea  · 
    • 6 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        1 comment  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
        Anonymous shared this idea  · 
      • 650 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          26 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
          Anonymous supported this idea  · 
          Anonymous commented  · 

          Why does MS Keep prioritizing SQL over Azure SQL? Azure SQL is the future. Get with the program guys.

        • 1,487 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            64 comments  ·  Networking » IPv6  ·  Flag idea as inappropriate…  ·  Admin →
          • 34 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              0 comments  ·  SQL Data Warehouse » Polybase  ·  Flag idea as inappropriate…  ·  Admin →
              Anonymous shared this idea  · 
            • 3,632 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                108 comments  ·  Azure Cosmos DB  ·  Flag idea as inappropriate…  ·  Admin →
                Anonymous supported this idea  · 
              • 470 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  4 comments  ·  Azure Cosmos DB  ·  Flag idea as inappropriate…  ·  Admin →

                  Thank you for your feedback. I have discussed this in more detail with our team.

                  You are correct the workaround suggested to use .AsEnumerable().FirstOrDefault(). should not be a recommended work around. This way results in materializing all documents on the client first before getting the 1st document, which is not very efficient and the exact opposite of what you are trying to achieve.

                  Instead we recommend you use Take(1).AsEnumerable() and then .First() or .Single() or .FirstOrDefault() for Single() and First(). Take(1) is translated to SELECT TOP 1 and is processed server-side so more efficient than the previous suggestion and is what you are trying to achieve.

                  As to the original ask. The support for these operations can be done, but this work is not prioritized against the other work we want to deliver. I will move this back as unplanned but please note this is on our roadmap.

                  Thanks again…

                  Anonymous supported this idea  · 

                Feedback and Knowledge Base