Daniel Smith

My feedback

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

    We’ll send you updates on this idea

    2 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 158

    <=-=Dec 4 2009 10:01PM=-=>

    I think this goes further than computed columns, as a filtered index can’t be used for something as simple as WHERE num % 2 = 0 (with no computed columns in sight). I really want to see filtered indexes become more useful.

    <=-=Dec 7 2009 10:29AM=-=>

    Greg,

    Thanks for your feedback. I agree we should allow filtered indexes on persisted computed columns, and should support more complex filter expressions, at some point in the future. We restricted the functionality for the first version but we’ll consider this for a future release. The documentation should be more precise about the restrictions on predicate expressions. I’ll follow up on that.

    Best regards,
    Eric

    <=-=Dec 8 2009 8:56PM=-=>

    I was AMAZED when I could not create a filtered index on computed column.

    But I as APPALLED and DUMBFOUNDED when I could not create a filtered indexes on…

    An error occurred while saving the comment
    Daniel Smith commented  · 

    It's the 10 year (!) anniversary from when this was originally requested on Connect.

    Persisted computed column should be treated the same as any other column and supported - surely this should be a fairly straight forward change to remove the unnecessary restriction for this specific case.

    An error occurred while saving the comment
    Daniel Smith commented  · 

    Any progress with this? There's the potential for some nice performance wins with this, if it can be enabled.

    Daniel Smith supported this idea  · 
  2. 47 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Daniel Smith commented  · 

    This had hundreds of votes on Connect before it was shut down. When will this be resolved?

    Daniel Smith supported this idea  · 
  3. 9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Daniel Smith commented  · 

    @Joe - what happened to your suggestion titled "Put Debugger back into SSMS 18"? It was the 4th highest rated item for SQL Server and it seems to have disappeared. Any idea what happened to it?

  4. 1,195 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    649 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Smith supported this idea  · 
  5. 931 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  362 comments  ·  SQL Server  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Daniel Smith commented  · 

    This is an absolute outrage. No community feedback was sought before this was removed - not even a warning that it was being considered. When I read the release notes, I could scarcely believe my eyes.

    Yes, we can use Visual Studio instead, but it's such a lengthy cumbersome process if you don't have a project already set up for the particular DB that you need to work with.

    Almost none of my clients have Visual Studio installed on their SQL Servers, and if there's ever a need to debug something on site, this is going to be a tremendous nightmare.

    Daniel Smith supported this idea  · 
  6. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Mar 2 2009 11:59AM=-=>

    Dear Mike,

    Thank you very much for your suggestion. Create a computed index/statistic without actually persisting a computed column in the base table would indeed be beneficial to cardinality estimates in the query optimizer. The Query processing team unfortunatelly has decided that such change is beyond the scope of a service pack for SQL 2008 and is currently tracking it in the next major release of SQL Server.

    Thanks,
    Yavor
    Program Manager
    SQL Engine

    <=-=Jan 25 2012 4:24PM=-=>

    We resolved this as a duplicate of another item. We’re tracking the request with the other item.

    Best regards,
    Eric Hanson
    Program Manger
    SQL Server Query Processing

    Daniel Smith supported this idea  · 
  7. 211 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  21 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Smith supported this idea  · 
  8. 893 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  155 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Daniel Smith commented  · 

    Hopefully .NET Core 3.0 support is high on the priority list for the team.

    Daniel Smith supported this idea  · 
  9. 927 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    138 comments  ·  Virtual Machines  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Smith supported this idea  · 
  10. 1,673 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    173 comments  ·  Azure Resource Manager  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Daniel Smith commented  · 

    What a disappointing response to the highest voted issue for the Resource Manager team.

    Can you please give us some details as to why this is so complicated to implement? Isn't the name just stored once against the resource group itself? Surely items are linked to resource groups by GUID rather than name?

    Daniel Smith supported this idea  · 
  11. 423 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    13 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 8

    <=-=Mar 5 2017 2:42PM=-=>

    Thanks for this idea. This is a valid requirement and I hope that it will get more votes. Currently we cannot confirm when it will be added, but it is in our backlog.

    <=-=May 22 2017 5:03AM=-=>

    would like it very much, particularly since you already have the CONCAT / GREATEST() a variable number of paramenters and does something with it…

    <=-=Jun 5 2017 12:31PM=-=>

    GREATEST / LEAST functions would be fantastic addition.

    <=-=Nov 14 2017 3:42PM=-=>

    The workarounds using CROSS APPLY or CASE expressions are difficult to manage and read. I’d love to see these implemented.

    Daniel Smith supported this idea  · 
  12. 12 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Virtual Machines » Windows  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Smith shared this idea  · 
  13. 1,301 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Folks,

    Thanks for the questions and suggestions. And apologies for not sharing any update on this thread for so long. We’ve been working on this problem and have announced changes on our official team blog (see here: https://cloudblogs.microsoft.com/enterprisemobility/2016/09/15/cleaning-up-the-azure-ad-and-microsoft-account-overlap/).

    First, we are acutely aware of the UX pain this is causing and we are sorry for this. We are trying to undo a decade and a half of systems divergence. There are literally hundreds of different engineering teams across Microsoft involved in this effort. So this is taking time.

    Second, we can’t easily “merge” two accounts, or allow IT to “take over” personal Microsoft accounts. There are two main hurdles: (1) The terms of service are fundamentally different for the two account types and (2) they are based on different technologies with different stacks (different identifiers, SDKs, token formats, etc.). We’re working to converge the two stacks but again this…

    Daniel Smith supported this idea  · 
  14. 1,135 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    74 comments  ·  Azure portal » Resource management  ·  Flag idea as inappropriate…  ·  Admin →

    Hey Folks,

    We have made some great progress on this idea and most of our services today do support move resources across groups.

    We are still working towards 100% support and while we do that it would be great if you can help us prioritize the missing services.

    Please file individual asks on each service category present in uservoice and vote for it.

    Thanks,
    Azure Portal Team

    Daniel Smith supported this idea  · 
  15. 996 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    50 comments  ·  Azure portal » Resource management  ·  Flag idea as inappropriate…  ·  Admin →

    Hey Folks,

    We have made some great progress on this idea and most of our services today do support move resources across groups.

    We are still working towards 100% support and while we do that it would be great if you can help us prioritize the missing services.

    Please file individual asks on each service category present in uservoice and vote for it.

    Thanks,
    Azure Portal Team

    An error occurred while saving the comment
    Daniel Smith commented  · 

    Whilst it's great that some resources can now be moved between subscriptions, there is still a major limitation that you can only move resources between subscriptions within a directory.

    As a co-admin of multiple directories, it's very frustrating that I'm not able to transfer to a subscription in any of the other directories I have access to. Please consider lifting this restriction, as it shouldn't be this painful just to move resources about.

    Daniel Smith supported this idea  · 
  16. 716 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    started  ·  115 comments  ·  Azure portal » Search + navigation  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Smith supported this idea  · 
  17. 442 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    unplanned  ·  91 comments  ·  Azure portal » Resource management  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Smith supported this idea  · 
  18. 245 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    22 comments  ·  Azure portal » Resource management  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Smith supported this idea  · 
  19. 1,170 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    36 comments  ·  Cloud Services (Web and Worker Role)  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Smith supported this idea  · 
  20. 226 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Cloud Services (Web and Worker Role)  ·  Flag idea as inappropriate…  ·  Admin →

    We’re thinking about some networking updates across the platform that will enable this feature. Thanks for your feedback

    Daniel Smith supported this idea  · 
← Previous 1

Feedback and Knowledge Base