Razvan Socol

My feedback

  1. 613 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    30 comments  ·  Signup and Billing  ·  Flag idea as inappropriate…  ·  Admin →
    Razvan Socol supported this idea  · 
  2. 505 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    76 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Razvan Socol supported this idea  · 
  3. 2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Razvan Socol commented  · 

    The issue still appears in SSMS 18.2 (as well as in SSMS 17.9.1).

    Razvan Socol shared this idea  · 
  4. 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 →
    Razvan Socol supported this idea  · 
  5. 24 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 577

    <=-=Dec 13 2007 3:33PM=-=>

    Dear Itzik.

    Thanks a lot for your feedback… and the strong voting support for this feature. Indeed, as you know, I am very much in favor of extending our functionality in this area. For a variety of reasons we did not get this into SQL Server 2008, but we are certainly looking into it for a future release.

    Keep the votes and comments coming…
    Michael

    PS: My apologies for the late official reply…

    <=-=Mar 10 2009 4:37PM=-=>

    I am a big fan of the ranking functions and partition by clause. I used them extensively. It was a fantastic inclusion in 2005. However, I can’t tell the number of times I wished DISTINCT worked with the count function. I can’t believe it wasn’t included in 2008!! So I’ve added my vote to get this in ASAP.

    <=-=Sep 15 2009 7:08AM=-=>

    yes this would be…

    Razvan Socol supported this idea  · 
  6. 93 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    20 comments  ·  SQL Server » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Razvan Socol supported this idea  · 
  7. 18 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  10 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Razvan Socol supported this idea  · 
  8. 26 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 11

    <=-=Jul 15 2016 6:51AM=-=>

    I offer as evidence for the desire for this to happen, the 1k+ views of my stackoverflow question from 2011. A little under a person a day.

    http://dba.stackexchange.com/questions/3828/is-there-a-collation-to-sort-the-following-strings-in-the-following-order-1-2-3?noredirect=1#comment273118_3828

    <=-=Jul 15 2016 8:40AM=-=>

    Adding to the link that Justin posted to his Stack Overflow question:

    http://dba.stackexchange.com/questions/117379/sort-a-varchar-type-column
    http://dba.stackexchange.com/questions/126744/order-by-and-comparison-of-mixed-strings-of-letters-and-numbers

    http://stackoverflow.com/questions/34509/natural-human-alpha-numeric-sort-in-microsoft-sql-2005
    http://stackoverflow.com/questions/3158917/natural-sort-for-sql-server
    http://stackoverflow.com/questions/22461619/complex-sort-of-field-string-number-string
    http://stackoverflow.com/questions/24989365/sorting-a-string-numerically-in-sql-server
    http://stackoverflow.com/questions/26552435/sorting-mixed-numbers-and-letters
    http://stackoverflow.com/questions/26932310/sql-server-string-convert-numeric-and-sorting-issue
    http://stackoverflow.com/questions/28278467/sort-dropdown-list-in-alpha-numeric-order
    http://stackoverflow.com/questions/28372359/natural-sort-for-sql-server
    http://stackoverflow.com/questions/29676432/alphanumeric-sort
    http://stackoverflow.com/questions/30502118/sort-float-numbers-as-a-natural-numbers-in-sql-server
    http://stackoverflow.com/questions/35001818/alphanumeric-and-numeric-sorting-in-sql-server
    http://stackoverflow.com/questions/37728476/sql-sorting-numeric-and-string

    http://www.codeproject.com/Articles/51602/How-to-Sort-Alphanumeric-Data-in-SQL

    <=-=Mar 3 2017 1:02PM=-=>

    We understand the scenario and if it gets more votes we will consider it for the next releases. It is assigned to our collation & string processing team.

    Razvan Socol supported this idea  · 
  9. 10 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: 258

    <=-=Apr 6 2008 6:30PM=-=>

    Hi Erland,

    Thank you for your suggestion. We will investigate a solution for a future version of SQL Server (post 2008).

    Il-Sung Lee.

    <=-=Jun 11 2010 12:51PM=-=>

    Surely a change could also be made to SSMS as well? When it parses master.sys.databases it could conceivably filter those results. Whilst not a foolproof method, at least it would work as a quick temporary solution (considering this was posted 3 yrs ago).

    <=-=Sep 23 2010 4:12PM=-=>

    The problem with changing SSMS is that it doesn’t strictly fix the issue as anyone who is determined to discover the other databases would just directly query the server metadata. As such, I think we need to investigate a solution this for all cases, not just SSMS.

    Il-Sung.

    <=-=Aug 3 2011 7:12AM=-=>

    Has there been any new development for this suggestion? As an organization, we’d like to see this…

    Razvan Socol supported this idea  · 
  10. 83 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  3 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Razvan Socol supported this idea  · 
  11. 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 » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 2

    <=-=Apr 30 2008 4:25PM=-=>

    Dear customer,

    Thank you for reporting this issue. You are right about the problem. In SQL Server 2005, we made changes to “compute scalar” operator. As a result, “computer scalar” operator does not have runtime information about actual rows any more. Please see http://msdn.microsoft.com/en-us/library/ms178082.aspx. That’s also why in the stats profile, you got 0 actual rows for “compute scalar”. We agree that this is confusing. We are working on this issue.

    Thanks,
    Leo Huang
    SQL Server Relational Engine Team

    <=-=Feb 1 2012 11:56AM=-=>

    Hello,

    Thank you for submitting this feedback, but given its priority relative to the many other items in our queue, it is unlikely that we will actually complete it. As such, we are closing this feedback as �won�t fix�. If you feel that this is worth reconsidering, feel free to respond to this message and we will take another look.

    Razvan Socol supported this idea  · 
  12. 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 » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Mar 21 2006 5:56PM=-=>

    Thanks for pointing this out! I’ve fixed the format error in the source document. You should see this in the next web update. -willisj

    <=-=May 1 2006 1:59AM=-=>

    I saw that you replaced the underlines with spaces in Books Online SP1 (apr.2006). But it wasn’t just a formatting error: the text should be different, for example “USER MAPPED TO CERTIFICATE” instead of “CERTIFICATE MAPPED USER”, “ROLE” instead of “DATABASE ROLE”. (you can run the statement I wrote in the “Steps to Reproduce” section to verify this, but should get the correct values by talking to developers team).

    Razvan

    <=-=May 1 2006 8:12AM=-=>

    Hello. I appreciate the feedback. In some of the beta releases the view did return terms with underscores rather than spaces. That has been changed in the view and also in the documentation. Thanks!!…

    Razvan Socol supported this idea  · 
  13. 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 » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Razvan Socol supported this idea  · 
  14. 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 » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Razvan Socol supported this idea  · 
  15. 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 » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 10

    <=-=Aug 11 2008 12:23PM=-=>

    Dear Customer,
    Thanks for your feedback. QUERYTRACEON was originally used for testing purposes and was not intended to be published. Although we agree that it would be useful to customers, for the time being we cannot recommend its usage. We did a thorough analysis of the current implementation and functionality of QUERYTRACEON and eventually decided that we cannot fully guarantee its reliability and consistency and therefore cannot recommend to use it. Moreover, the implications of toggling global (per server) and local (per session) trace flags on a per-query basis are not straightforward and add to the complexity of this switch. The entire issue came up late in the release cycle of SQL Server 2008 and did not meet the bar anymore, so we had to postpone the documentation to the next release.
    With best regards,
    Roman Schindlauer

    <=-=Apr 14 2013 3:41PM=-=>

    Some information on …

    Razvan Socol supported this idea  · 
  16. 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 » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 12

    <=-=Apr 14 2017 4:31PM=-=>

    Thanks for reporting, this issue will be addressed in an upcoming cumulative update of service pack 1

    -SSRS team

    <=-=Apr 14 2017 4:31PM=-=>

    Thanks for reporting, this issue will be addressed in an upcoming cumulative update of service pack 1

    -SSRS team

    <=-=May 30 2017 1:37PM=-=>

    Any update on the timeline for this fix?

    <=-=Jul 4 2017 7:05AM=-=>

    List View Bug came back in SP1 CU3. (See https://connect.microsoft.com/SQLServer/feedback/details/3134731/ssrs-2016-sp1-cu3-list-view-report-bug)

    <=-=Sep 11 2017 9:35AM=-=>

    This bug was fixed in SP1 CU3 (see https://support.microsoft.com/en-us/help/4015093/fix-rsunknownreportparameter-error-when-you-click-a-report-from-search).
    The other related bug which was introduced in SP1 CU3 (https://connect.microsoft.com/SQLServer/feedback/details/3134731/ssrs-2016-sp1-cu3-list-view-report-bug), was fixed in CU4.
    Conclusion: install SP1 CU4 if you have applied SP1 and you use SSRS.

    Razvan Socol supported this idea  · 
  17. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Upvotes: 1

    <=-=Dec 29 2017 2:40PM=-=>

    Hi Razvan,

    Thank you for reporting this bug. We were able to reproduce the issue you reported and are exploring ways to fix this. Meanwhile, could you please let me know if this is a blocker bug for you?

    Thanks,
    shreya

    <=-=Dec 29 2017 9:26PM=-=>

    No, it is not a blocker. I was just exploring graph tables, I am not using them in production yet.

    Razvan Socol commented  · 

    Although the bug was still present in SQL Server 2017 RTM CU1, it seems that it is fixed in SQL Server 2017 RTM CU4 (but I did not find it in the list of hotfixes included in CU2, CU3 or CU4).

    Razvan Socol commented  · 

    The "Steps to Reproduce" section was lost when migrating from Connect to UserVoice. It contained the following script:

    DROP TABLE IF EXISTS dbo.Edges
    CREATE TABLE Edges AS EDGE
    CREATE CLUSTERED COLUMNSTORE INDEX I1 ON Edges
    CREATE INDEX I2 ON dbo.Edges ($from_id, $to_id)

    Razvan Socol supported this idea  · 

Feedback and Knowledge Base