Vladimir Moldovanenko

My feedback

  1. 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 →
    Vladimir Moldovanenko commented  · 

    Indeed, good catch, I get error

    Msg 109, Level 20, State 0, Line 0
    A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)

    and dump

    2019-09-30 15:02:51.22 spid53 * Short Stack Dump
    2019-09-30 15:02:51.25 spid53 00007FFD8DBAA839 Module(KERNELBASE+000000000003A839)
    2019-09-30 15:02:51.25 spid53 00007FFD739A614E Module(sqllang+0000000000FB614E)
    2019-09-30 15:02:51.26 spid53 00007FFD739AA0ED Module(sqllang+0000000000FBA0ED)
    2019-09-30 15:02:51.27 spid53 00007FFD72D365C9 Module(sqllang+00000000003465C9)
    2019-09-30 15:02:51.27 spid53 00007FFD71BCCDCF Module(sqldk+000000000005CDCF)
    2019-09-30 15:02:51.27 spid53 00007FFD71BF036F Module(sqldk+000000000008036F)
    2019-09-30 15:02:51.30 spid53 00007FFD71BEC977 Module(sqldk+000000000007C977)
    2019-09-30 15:02:51.30 spid53 00007FFD757CE320 Module(sqlmin+00000000001DE320)
    2019-09-30 15:02:51.30 spid53 00007FFD7564BD94 Module(sqlmin+000000000005BD94)
    2019-09-30 15:02:51.30 spid53 00007FFD7564D743 Module(sqlmin+000000000005D743)
    2019-09-30 15:02:51.30 spid53 00007FFD7564D5F6 Module(sqlmin+000000000005D5F6)
    2019-09-30 15:02:51.31 spid53 00007FFD7564E340 Module(sqlmin+000000000005E340)
    2019-09-30 15:02:51.31 spid53 00007FFD720A1EC7 Module(sqlTsEs+0000000000001EC7)
    2019-09-30 15:02:51.31 spid53 00007FFD75708623 Module(sqlmin+0000000000118623)
    2019-09-30 15:02:51.31 spid53 00007FFD7562A7BF Module(sqlmin+000000000003A7BF)
    2019-09-30 15:02:51.31 spid53 00007FFD72A06092 Module(sqllang+0000000000016092)
    2019-09-30 15:02:51.31 spid53 00007FFD72A06249 Module(sqllang+0000000000016249)
    2019-09-30 15:02:51.31 spid53 00007FFD72A046C0 Module(sqllang+00000000000146C0)
    2019-09-30 15:02:51.31 spid53 00007FFD72A04123 Module(sqllang+0000000000014123)
    2019-09-30 15:02:51.31 spid53 00007FFD72A03764 Module(sqllang+0000000000013764)
    2019-09-30 15:02:51.31 spid53 00007FFD72A0D9DD Module(sqllang+000000000001D9DD)
    2019-09-30 15:02:51.31 spid53 00007FFD72A0BEF2 Module(sqllang+000000000001BEF2)
    2019-09-30 15:02:51.32 spid53 00007FFD72A0BCE3 Module(sqllang+000000000001BCE3)
    2019-09-30 15:02:51.32 spid53 00007FFD71B753CD Module(sqldk+00000000000053CD)
    2019-09-30 15:02:51.32 spid53 00007FFD71B75018 Module(sqldk+0000000000005018)
    2019-09-30 15:02:51.32 spid53 00007FFD71B74E0D Module(sqldk+0000000000004E0D)
    2019-09-30 15:02:51.32 spid53 00007FFD71B98C48 Module(sqldk+0000000000028C48)
    2019-09-30 15:02:51.32 spid53 00007FFD71B99190 Module(sqldk+0000000000029190)
    2019-09-30 15:02:51.32 spid53 00007FFD71B98387 Module(sqldk+0000000000028387)
    2019-09-30 15:02:51.32 spid53 00007FFD71B988D9 Module(sqldk+00000000000288D9)
    2019-09-30 15:02:51.32 spid53 00007FFD8FFE7BD4 Module(KERNEL32+0000000000017BD4)
    2019-09-30 15:02:51.32 spid53 00007FFD9016CED1 Module(ntdll+000000000006CED1)
    2019-09-30 15:02:51.33 spid53 Stack Signature for the dump is 0x0000000149AF925E
    2019-09-30 15:02:52.07 spid53 DumpCallbackHk::CreateCabFile: at 2152 g_CabDdfFile file is null, normally because nocollectors added any files, exiting
    2019-09-30 15:02:52.07 spid53 DumpCallbackHk::CollectFiles: at 571 failed at CreateCabFile with error: 0x80004005
    2019-09-30 15:02:52.91 spid53 External dump process return code 0x20000001.
    External dump process returned no errors.

    Vladimir Moldovanenko supported this idea  · 
  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 →
    Vladimir Moldovanenko commented  · 

    No issue here, just poor coding. Use table and column aliases and this will not be a problem

  3. 3 votes
    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 →
    Vladimir Moldovanenko supported 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

    1 comment  ·  SQL Server » Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
    Vladimir Moldovanenko commented  · 

    Disagree. I want to be in control of what gets installed and when so I do not loose diagrams or debugging tools

  5. 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 →
    Vladimir Moldovanenko commented  · 

    You are running RTM. try latest *** update, 16, at https://www.microsoft.com/en-us/download/details.aspx?id=56128
    See if this helps

  6. 3 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 →
    Vladimir Moldovanenko commented  · 

    Hi. This spring I have worked extensively for few months with Microsoft on this issue. It is improved a lot in SSMS 18.2. Try it, it should be better

  7. 12 votes
    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 →
    Vladimir Moldovanenko supported this idea  · 
  8. 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 →
    Vladimir Moldovanenko shared this idea  · 
  9. 3 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 →
    Vladimir Moldovanenko supported this idea  · 
  10. 5 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 » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Vladimir Moldovanenko commented  · 

    ...present/available?

    Vladimir Moldovanenko commented  · 

    I am curious as to why adding this time is great? there has been 'duration' on status bar for a long time already and enabling 'Include Client Statistics' showed execution time per query execution. How is adding start time going to help in addition to information/values already?

  11. 6 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 →
    Vladimir Moldovanenko commented  · 

    I would argue it's pretty useless considering there is duration on status bar.

    So if someone finds it useful, fine. then why not just have it on the same line as the first message? Like so

    Commands completed successfully at 2019-07-29T16:31:27.4723989-05:00

  12. 1 vote
    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 →
    Vladimir Moldovanenko commented  · 

    Still in SSMS 18.1

    Vladimir Moldovanenko commented  · 

    Also happens in SSMS 18.6

    Vladimir Moldovanenko commented  · 

    It is on SQL Server 2017 Cumulative Update 3

    Vladimir Moldovanenko shared this idea  · 
  13. 167 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Thanks everybody for providing the list. I’ve passed the info to the Visual Studio Team.

    In the meanwhile, I have 2 more requests:
    1) If you happen to have Visual Studio 2017 (version 15.9.11 or greater), could you check and see if it shows the same behavior?
    2) If you happen to have SSMS 17.9.1 on the same machine, could you check and see if it shows the same behavior?

    I’m hearing from folks here that “changing SSMS such that it disables h/w acceleration by default” is not a recommended thing to do… However, quite honestly, at this point, it may be the only option I can think about.. :-(

    -Matteo

    Vladimir Moldovanenko commented  · 

    Dell laptop with Intel HD Graphics 630 and Nvidia Quadro M 1200, using built-in LCD and 2 external Dell 27" monitors. SSMS is almost always on an external monitor

    Vladimir Moldovanenko supported this idea  · 
  14. 120 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    57 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Vladimir Moldovanenko supported this idea  · 
  15. 124 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  4 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Vladimir Moldovanenko supported this idea  · 
    Vladimir Moldovanenko commented  · 

    SQL Server Broker was requested as a new target for Extended Events. Some parts of this were delivered in SQL 2017 but it still does not work.

    See details and vote up here https://feedback.azure.com/forums/908035-sql-server/suggestions/33146815-service-broker-target-not-functional-on-extended-e

    Once this works you can capture and whatever you want with extended events, even INSERT these into your own table, either by RECEIVEing from queue or having activation procedure coded to do what you want.

  16. 56 votes
    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 →
    Vladimir Moldovanenko supported this idea  · 
  17. 50 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 » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 54

    <=-=Sep 4 2007 12:29PM=-=>

    If this is considered for a future version of SQL Server, please implement it according to the ISO SQL standard. In other words, implement the SQL Standard , which provides regular expression support through the operator [NOT] SIMILAR TO, which in the standard remains separate from LIKE.

    <=-=Sep 5 2007 7:05AM=-=>

    Like Steve, I would also like to stress that any implementation should be as per ANSI (SIMILAR predicate). The CLR functionality is not a relevant design consideration.

    <=-=Oct 15 2007 8:43AM=-=>

    This is a request we’ve heard a lot, and it’s of obvious value. I can’t promise when we’ll get to it—-it’s doubtful for this release—-but this is certainly on our radar.

    Cheers,
    -Isaac

    <=-=Mar 24 2010 2:54PM=-=>

    Hi,
    I have resolved this request as duplicate of feedback item below:

    https://connect.microsoft.com/SQLServer/feedback/details/261342/regex-functionality-in-pattern-matching?wa=wsignin1.0


    Umachandar, SQL Programmability Team

    <=-=Mar 24 2010…
    Vladimir Moldovanenko supported this idea  · 
  18. 44 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 » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 407

    <=-=Oct 11 2007 4:28AM=-=>

    ANS SQL 99 actualy defines a syntax (section 11.49) for function definition that can be used for an inline scalar function (body consisting of a single RETURN statement) – inlining being an implementation rather than a definitional issue. There are other database products (e.g. IBM DB2 UDB) that already support this, so going the ANS way would assist portability.

    The enhancement is clearly necessary.

    <=-=Oct 11 2007 8:45AM=-=>

    In other programming languages, this might be a macro expansion, where an include file contains the macro, which expands into inline code at compile time. (I believe that this was discussed as a possibility in the very early days of Yukon.) In any case, however implemented, Inline Scalar UDF would be a major improvement over the speed-bump that exists now.

    I was going to post this myself, but happily add my vote to the existing…

    Vladimir Moldovanenko supported this idea  · 
  19. 65 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: 60

    <=-=Mar 29 2017 11:32PM=-=>

    Just wanted to add that both Oracle and DB2 seem to support this feature:

    http://docs.oracle.com/database/122/SQLRF/LAG.htm#SQLRF00652
    https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_1513.htm

    Cheers,
    Itzik

    <=-=Apr 16 2017 10:08PM=-=>

    That last IBM link was for Informix!

    The DB2 link is https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0023461.html

    <=-=Jul 4 2017 3:30AM=-=>

    Thanks for reporting this request.
    It is in our backlog, and we have planned to do something like this, but we cannot confirm when it would be completed.

    Jovan

    <=-=Jul 10 2017 11:54AM=-=>

    Thanks, Jovan; good to hear.

    Vladimir Moldovanenko supported this idea  · 
  20. 55 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 →
    Vladimir Moldovanenko supported this idea  · 
← Previous 1 3 4 5

Feedback and Knowledge Base