Hopes for vNext

  • Comments posted to this topic are about the item Hopes for vNext

  • From someone in a highly regulated industry: SQL Audit needs to be a separate and distinct product apart from the main offerings, a la Guardium. We can’t use an auditing tool that is under the control of a SQL sysadmin.

  • Given that the name is misleading, certainly in terms of how many people claim to understand it, I would personally change the NOLOCK hint name to IDeliberatelyCodedThisJoinToReturnCrap.  With immediate effect, no backward compatibility.

    I honestly don't know if the increased accuracy in the naming would stop people mis-using it as such, but there is a hope that those using it out of laziness may be too lazy to type it out in full.  Obviously, those using it properly, where appropriate, already know the way it works so hopefully shouldn't be too fussed.

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • It's been on the ask list for Microsoft ever since they introduced the function, but STRING_SPLIT providing the ordinal position of values in the string is something that I really wish they would do. I realise that it may well be a breaking change, due to people using SELECT * far too commonly so if they don't want that happening they could introduce a second function that does return it.

    Having it in the function is really important, as it's documented that is doesn't guarantee that the order of the values will be the same as they were in the string, and I commonly see people using ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) or similar to "get the ordinal position"; that is not going to work at some point and could be very bad.

    Of course, we all know that storing delimited data in an RDBMS is a big "no-no", but there are unfortunately often times we have to deal with it, either as incoming data and a historically poorly designed database, and making that dealing reliable and performant is really important.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • I have several pet peeves about the Filter Settings dialog in SSMS.

    Adding Filter Operators such as Starts With or ends with to the dropdown

    In more detail, the navigation on this screen is ridiculous. Here are a handful of ways to make it more user-friendly.

     

  • String Split would be easy. Add an optional parameter that adds an "order" column. I'm not sure why they won't do this one.

    For SSMS, lots of ergonomic things would help, though since this depends on the VS shell, I have no idea how hard these are to change.

    NOLOCK is never going away.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply