Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

Todd Chittenden

My feedback

  1. 2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    Todd Chittenden shared this idea  · 
  2. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    Todd Chittenden shared this idea  · 
  3. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data Factory  ·  Flag idea as inappropriate…  ·  Admin →
    Todd Chittenden shared this idea  · 
  4. 24 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  11 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Todd Chittenden commented  · 

    Over two years and counting and still no acknowledgement from Microsoft. Are they ignoring this issue, too embarrassed to admit they wrote this piece of junk?

  5. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Todd Chittenden shared this idea  · 
  6. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Todd Chittenden commented  · 

    Same thing happens for v18.6. (a.k.a. 15.0.18388.0). This is a BUG and should be fixed regardless of VOTES here. Is there an internal Microsoft tracking item for this?

    And while we're at it, which *Version* should be we reporting off of, the one that shows up on the splash screen and Download site, or the one that displays in Help >> About. Why are these not the same? Frustrated that Microsoft can't even get THAT right.

  7. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Todd Chittenden commented  · 

    I would love to open a conversation with Microsoft about the LACK of information regarding the documentation page here: https://docs.microsoft.com/en-us/analysis-services/tabular-models/process-tabular-model-partitions-ssas-tabular?view=asallproducts-allversions

    I'm doing the the "Process Add" because my partition already contain data for the year, all I need to do is incrementally add the data that has been incrementally added to the SQL database in the past hour. ADD seems to be the choice, based on the documentation.

    "Incrementally update the partition with new data." ACTUAL RESULT: Existing rows get added AGAIN.

    And where is the XMLS equivalent of each of these command options?

    Thank GOODNESS that SSMS has the ability to script out commands from dialog boxes!!!

    LESS THAN IDEAL USER EXPERIENCE as I'm CONSTANTLY experimenting with different options because the documentation is NOT helpful.

    An error occurred while saving the comment
    Todd Chittenden commented  · 

    Guys, thanks for the tips. So I tried it out and it works great. BUT, there is something I don't understand: My model is not that large, maybe two years worth of data, a few hundred K rows total. I can PROCESS FULL the entire database in 1:10, but PROCESS ADD on only two of the 12 tables takes 1:23

    So what's my motivation for doing incremental processing here? I would have expected it to be a lot faster. Instead it slower by 10%

    An error occurred while saving the comment
    Todd Chittenden commented  · 

    Oh, and they need to be more clear in their definition of “partially processed” in the documentation.

    An error occurred while saving the comment
    Todd Chittenden commented  · 

    Ok, what’s the XMLA command equivalent of “Process Add”
    I bet a dollar it’s NOT “processAdd”. THAT would just make too much sense ☺️

    Todd Chittenden shared this idea  · 
  8. 50 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  3 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Todd Chittenden supported this idea  · 
  9. 74 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Todd Chittenden supported this idea  · 
  10. 580 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    35 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →

    This is not currently planned for the normal SQL DB since the databases within a logical server are not hosted within a single server like in SQL Server – they have multiple replicas that are independently placed on different servers due to the high availability architecture in SQL Azure. However, SQL Azure Managed Instance supports use database as a command because all of the databases in that model are on the same SQL instance – just like SQL Server. It is therefore recommended that you consider Managed Instance for migrations from on-premises SQL Server where you can not/do not wish to modify behavior to fit within a single SQL Azure DB.

    Topic left open for comments and voting, but please note that some of the comments left do not seem to recognize that SQL Managed Instance is available and recommended by Microsoft for many of the use cases listed. We…

    Todd Chittenden supported this idea  · 
  11. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Todd Chittenden shared this idea  · 
  12. 5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Todd Chittenden commented  · 

    And what the **** is with the Version numbers? Is it 18, or is it 15? Depends on where you look.

    Todd Chittenden shared this idea  · 
  13. 224 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    36 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Todd Chittenden commented  · 

    SSMS splash screen tells you it is “powered by Visual Studio”. So why can it NOT take advantage of VS standard features?

    Todd Chittenden supported this idea  · 
  14. 349 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Upvotes: 127

    <=-=Jun 23 2015 8:37AM=-=>

    I’m the first to post a useful comment. This must make me special.

    Seriously though, this would be an excellent solution to having to create a new “scratchdb” to hold my interim ETL data. This would be a major plus in simplifying design of a high performance app.

    <=-=Jul 3 2015 5:04AM=-=>

    In 2014, memory optimized tables, and delayed durability can be used help mitigate these Issues. However neither of this are always completely viable solutions. Brent’s proposed solution is likely the simplest way to achieve this with the least amount of unwanted impact. It is important to note that other platforms implement similar functionality as well. Notably Oracle.

    <=-=Nov 29 2016 3:58PM=-=>

    There are so many good things about this suggestion. I am amazed that SQL does not have the capability to turn off logging for certain tables that you define as no…

    Todd Chittenden supported this idea  · 
  15. 379 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Upvotes: 249

    <=-=Oct 4 2016 2:15PM=-=>

    This is similar to my feedback located here: https://connect.microsoft.com/SQLServer/feedback/details/2769130/sql-2016-temporal-tables-with-triggers. The solution I suggest is similar to this, and could be used in many different cases developing using SQL server.

    <=-=Jan 10 2017 9:43AM=-=>

    I would love this too. The issue is that many/most applications don’t use Windows Auth in the connection to SQL Server (connection pooling issues, etc), so SQL can’t get the User information

    <=-=Jan 10 2017 9:51AM=-=>

    @Sanford

    Just to clarify, I am not asking for an “automatically store user name” feature. I’m asking for “automatically store whatever I want, based on whatever expression I provide.” So the fact that the user name may or may not be available is not really relevant.

    That said, there are plenty of workarounds for various situations. I imagine that if you’re using a shared connection, you can get some notion of “user” some other…

    Todd Chittenden supported this idea  · 
  16. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Todd Chittenden shared this idea  · 
  17. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Todd Chittenden shared this idea  · 
  18. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Azure mobile app  ·  Flag idea as inappropriate…  ·  Admin →
    Todd Chittenden shared this idea  · 
  19. 16 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Azure Portal » Resource management  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the valid suggestion. Your feedback is now open for the user community to upvote & comment on. This allows us to effectively prioritize your request against our existing feature backlog and also gives us insight into the potential impact of implementing the suggested feature.

    Todd Chittenden shared this idea  · 

Feedback and Knowledge Base