Solomon Rutzky

My feedback

  1. 1 vote
    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 →
    Solomon Rutzky supported this idea  · 
    An error occurred while saving the comment
  2. 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 →
    Solomon Rutzky supported this idea  · 
    An error occurred while saving the comment
  3. 4 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 » Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 11

    <=-=Aug 3 2015 10:28AM=-=>

    Hi Solomon,

    Thanks for submitting this feedback. Your suggestion makes a lot of sense. Unfortunately, we’ve evaluated this suggestion relative to our other development tasks and decided not to implement support for this functionality at this time. We appreciate that you took the time to submit this feedback, and we hope you’ll continue to share your ideas for improving our SQL Server tools in the future.

    Regards,
    Steven Green
    SQL Server developer tools team

    <=-=Mar 23 2016 1:26PM=-=>

    Because with no function overloading, optional parameters is the only way to provide multiple calling signatures for a function is defaults… which you refuse to implement.

    Does anybody at Microsoft actually use SSDT and SQLCLR?

    <=-=Feb 19 2017 10:48AM=-=>

    It is always two sides opinion, from MS side, MS thinks no many people are using CLR inside SQL Server, but on the other hand from…

    Solomon Rutzky supported this idea  · 
    An error occurred while saving the comment
  4. 5 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: 4

    <=-=Mar 6 2017 3:54PM=-=>

    Thanks for your feedback! We do not have any plans to change CLR user defined types at this time, but we will consider it for future releases.

    <=-=Mar 6 2017 3:55PM=-=>

    Thanks for your feedback! We do not have any plans to change CLR user defined types at this time, but we will consider it for future releases.

    Solomon Rutzky supported this idea  · 
    An error occurred while saving the comment
  5. 3 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 →
    An error occurred while saving the comment
    Solomon Rutzky commented  · 

    This was definitely a bug as reported here:

    https://support.microsoft.com/en-us/help/4096875/fix-access-is-denied-error-when-you-try-to-create-a-database-in-sql-se

    and discussed on DBA.StackExchange here:

    LocalDB v14 creates wrong path for mdf files ( https://dba.stackexchange.com/a/191748/30859 )

    Fortunately, this was fixed in the most recent Cumulative Update (CU6):

    https://support.microsoft.com/en-us/help/4047329

  6. 5 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Solomon Rutzky shared this idea  · 
  7. 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: 2

    <=-=May 23 2016 2:11PM=-=>

    I just discovered that this behavior is both known and deprecated; it is listed on the “Deprecated Database Engine Features in SQL Server 2016” MSDN page, in the “Features Not Supported in a Future Version of SQL Server” section ( https://msdn.microsoft.com/en-us/library/ms143729.aspx#Anchor_1 ):

    FeatureID = 185: Use of #, ## as temporary table and temporary stored procedure names.
    FeatureID = 186: Use of , @, or @@ as Transact-SQL identifiers.

    The earliest reference I could find for the deprecation notice was in the 2008 documentation:

    https://msdn.microsoft.com/en-us/library/ms143729(v=sql.100).aspx#Anchor_1

    <=-=May 24 2016 9:01AM=-=>

    I forgot to mention in the other comment that this item should probably be closed as “By Design”.

    An error occurred while saving the comment
    Solomon Rutzky commented  · 

    For a comprehensive list of how T-SQL Identifiers work, please see:

    Completely Complete List of Rules for T-SQL Identifiers ( https://sqlquantumleap.com/reference/completely-complete-list-of-rules-for-t-sql-identifiers )

    An error occurred while saving the comment
    Solomon Rutzky commented  · 
  8. 33 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.

    An error occurred while saving the comment
    Solomon Rutzky commented  · 
    Solomon Rutzky supported this idea  · 
  9. 4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Solomon Rutzky shared this idea  · 
  10. 0 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 →
    An error occurred while saving the comment
    Solomon Rutzky commented  · 

    Functionality to do this (for the most part) has been added to the SQL# SQLCLR library (which I wrote), available at:

    https://SQLsharp.com/

    The following two functions, both available in the Free version, convert between a BIGINT and a string of 1's and 0's:

    Convert_Base2ToBase10
    Convert_Base10ToBase2

    For example:

    SELECT SQL#.Convert_Base2ToBase10(N'1001');
    -- 9

    SELECT SQL#.Convert_Base10ToBase2(9);
    -- 0000000000000000000000000000000000000000000000000000000000001001

  11. 0 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 →
    An error occurred while saving the comment
    Solomon Rutzky commented  · 
  12. 0 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 →

    Upvotes: 4

    <=-=Mar 8 2017 10:25AM=-=>

    You have no idea how happy I am that someone has been able to reproduce this bug. I’ve been seeing this behaviour since SQL Server 2005, and my gross workaround was to remove GO from comments. Thank you so much for narrowing it down. In my case, it was always caused by the bracket.

    An error occurred while saving the comment
    Solomon Rutzky commented  · 

    This is either a duplicate of, or at least related to, the bug I submitted here:

    https://feedback.azure.com/forums/908035-sql-server/suggestions/32901208--go-in-2nd-half-of-nested-block-comments-breaks-b

  13. 9 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Solomon Rutzky supported this idea  · 
  14. 2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Solomon Rutzky commented  · 

    Hi Michael. The comments in your test script are a bit confusing as there is no "b.ColList" in the SELECT. It would help if it was a bit clearer showing both how to reproduce the error and otherwise. I *think* I see what you mean since if I move "REPLACE(b.TempTableColumnDef,b.TempTableColumnDef,N'') +" down a line or two then I seem to get 3000 or so less characters (19k down to 16k), and if I remove it then the entire thing becomes about 4001 characters.

    HOWEVER, I believe this is NOT a bug, but just user error due to inconsistent datatype usage (and inconsistent / incorrect line endings; that's not causing the problem, but still stick with either just LF or CRLF, not a mix, and if you choose both characters then use them in the correct order: 13 then 10). The main issue is that when one is building Dynamic SQL / scripts via T-SQL, you should only ever use NVARCHAR(MAX) as the datatype for ALL variables, and prefix ALL string constants / literals with an upper-case "N". The problem in your script is that while you do correctly declare some variables as SYSNAME, you then cast the XML (which is compressed, but still effectively the same as NVARCHAR(MAX)) to VARCHAR(8000). And none of your string literals have the "N" prefix.

    I changed the XML casting to be NVARCHAR(MAX) and prefixed most string literals with "N". Now I get nearly 1000 extra characters (just over 20k), _and_ if I comment out the "REPLACE(b.TempTableColumnDef,b.TempTableColumnDef,N'') +" line there is no truncation.

    Please do the following:
    1) change all casting to be NVARCHAR(MAX), not VARCHAR(8000)
    2) prefix ALL string literals with "N"
    3) declare a variable at the top for:
    DECLARE @CRLF NCHAR(2) = NCHAR(0x000D) + NCHAR(0x000A);
    4) change "CHAR(10) + CHAR(13)" to be: @CRLF
    5) change "CHAR(10)" to be: @CRLF

    Take care,
    Solomon
    https://SqlQuantumLeap.com/

  15. 2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Solomon Rutzky supported this idea  · 
1 2 3 4 5 7 Next →

Feedback and Knowledge Base