tag:blogger.com,1999:blog-862634293081385156.post821501935378641231..comments2024-03-05T04:36:00.117-03:00Comments on Javier Villegas - SQL Server DBA - Microsoft MVP Data Platform - MCTS / MCP: "SQL Advanced Monitoring" Session for PASS DBA Virtual ChapterJavier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-862634293081385156.post-20559485831767812502018-07-09T06:15:12.380-03:002018-07-09T06:15:12.380-03:00It was so nice article. I was really satisfied by ...It was so nice article. I was really satisfied by seeing this article. <a href="https://onlineitguru.com/Sql-server-dba-online-training-placement.html" rel="nofollow">SQL server dba Online Training </a>latesttechnologyblogshttps://www.blogger.com/profile/00537914353624338231noreply@blogger.comtag:blogger.com,1999:blog-862634293081385156.post-15259463986717571082018-07-09T06:04:47.830-03:002018-07-09T06:04:47.830-03:00It was so nice article. I was really satisfied by ...It was so nice article. I was really satisfied by seeing this article. <a href="https://onlineitguru.com/Sql-server-dba-online-training-placement.html" rel="nofollow">SQL server dba Online Training </a>latesttechnologyblogshttps://www.blogger.com/profile/00537914353624338231noreply@blogger.comtag:blogger.com,1999:blog-862634293081385156.post-27955836348728401422018-03-22T05:36:04.890-03:002018-03-22T05:36:04.890-03:00good information Sql Server dba Online Training Ba...good information <a href="https://onlineitguru.com/sql-server-dba-online-training-placement.html" rel="nofollow">Sql Server dba Online Training Bangalore</a>Anonymoushttps://www.blogger.com/profile/14157135109598143687noreply@blogger.comtag:blogger.com,1999:blog-862634293081385156.post-4963317387532223812016-04-17T14:53:10.287-03:002016-04-17T14:53:10.287-03:00This comment has been removed by the author.Billyhttps://www.blogger.com/profile/11511375399583753456noreply@blogger.comtag:blogger.com,1999:blog-862634293081385156.post-67012282435682387582016-03-27T07:56:42.325-03:002016-03-27T07:56:42.325-03:00Here we go
Create function dbo.FN_Str2VarBinary64...Here we go<br /><br />Create function dbo.FN_Str2VarBinary64 ( @Str varchar(max) )<br />returns varbinary(64)<br />as<br />Begin<br /> if @Str is null return null<br /><br /> Declare @Ret varbinary(64)<br /> Declare @HexStr varchar(max)<br /> Declare @I smallint<br /> Declare @C smallint<br /><br /> Set @Str = replace(@Str, '0x', '' )<br /> Set @I = 2<br /> Set @HexStr = ''<br /><br /> while 1=1<br /> Begin<br /> Set @C = charindex( substring(@Str, @I, 1), '0123456789abcdef' ) - 1<br /> if @C = -1<br /> break<br /> Set @HexStr = @HexStr + char( (16 * (charindex( substring(@Str, @I-1, 1), '0123456789abcdef' ) - 1) ) + @C )<br /> Set @I = @I + 2<br /> End <br /><br /> Set @Ret = convert(varbinary(64), @HexStr)<br /><br /> return @Ret<br />EndJavier Villegashttps://www.blogger.com/profile/05304689260580191971noreply@blogger.comtag:blogger.com,1999:blog-862634293081385156.post-43815703055913290302016-03-22T14:00:45.153-03:002016-03-22T14:00:45.153-03:00one of the functions was left out (dbo.FN_Str2VarB...one of the functions was left out (dbo.FN_Str2VarBinary64). Trying to set up your DeadLock XEVENT Advance MonitoringAnonymoushttps://www.blogger.com/profile/02728669935538967013noreply@blogger.com