SQL Server – Transact SQL - varbintohexsubstring

  • guido1971

    SSC Journeyman

    Points: 77

    Hello there, I need your appreciated help.

    My version is :

    Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) 
    Oct 14 2005 00:33:37
    Copyright (c) 1988-2005 Microsoft Corporation
    Standard Edition on Windows NT 6.1 (Build 7601: Service Pack 1)

    I have problem with this transaction :

    return sys.fn_varbintohexsubstring(1,@pbinin,1,0)

    Because on Activity Monitor of SQL Server this thread it takes up a lot of memory and a lot of CPU on the server.

    https://learningintheopen.org/2016/09/09/sql-server-transact-sql-what-is-return-sys-fn_varbintohexsubstring1pbinin10/

    How to do resolve this ?

    Thanks in advance for any help.

    Guido

    Immagine

    Immagine2

  • Daniel Adeniji-180202

    SSC Veteran

    Points: 208

    Guido :-

    You cannot really resolve the issue.

    Are you using encryption.

    If you are using encryption the varbintohexsubstring function is used by DecryptByKey and other decryption routines.

    Daniel Adeniji

     

     

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

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