SQL Server – Transact SQL - varbintohexsubstring

• guido1971

  SSC Enthusiast

  Points: 187

  More actions

  March 26, 2020 at 8:54 am

  #3737101

  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

  

  

• Daniel Adeniji-180202

  SSC Veteran

  Points: 233

  More actions

  March 26, 2020 at 4:52 pm

  #3737838

  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