sqlexpert

Interested in Haskell, Idris, Agda, F#, Scala, Clojure

Technical Article

LongestRunningQueries.vbs

This SQL 2005-only VBS script will show the longest-running queries on a given server, complete with graphical .sqlplan when clicked. Results go to a web page, viewed from the local machines's temp directory.Each row of the resulting table has the session ID, the currently running statement of the batch, a link to a text file […]

5 (1)

2007-07-24 (first published: )

341 reads

Technical Article

faster dbo.ufn_vbintohexstr - varbinary to hex

Here's an alternative to Clinton Herring's ufn_vbintohexstr which should be much faster with large varbinary values. First, in his original version, the inner-loop CASE statements can be replaced with this: select @value = @value + CHAR(@vbin/16+48+(@vbin+96)/256*7) +CHAR(@vbin&15+48+((@vbin&15)+6)/16*7) How does it work? By adding 6 to a hex-digit in (@vbin&15), you have a value from 16 […]

2006-12-20 (first published: )

85 reads

Technical Article

BASE64 Encode and Decode in T-SQL - optimized

This is just an optimized version of Daniel Payne's two scripts, base64_encode and base64_decode, with changes to end-of-block handling and a bug fix or two. If the encoded string ends in =, the last character is truncated. If ending in ==, two characters are chopped off. That seems better than replacing NUL characters with spaces, […]

4.8 (5)

2006-12-18 (first published: )

5,626 reads

Technical Article

HexToInt

Challenged by Hans Lindgren's stored procedures of the same name, I created this. Note that it produces strange results on non-hexadecimal strings, overflows at 0x80000000, and could have issues with byte-ordering on some architectures.How does it work? Well, the distance between one after '9' (':') and 'A' is 7 in ASCII. Also, if I subtract […]

2006-12-15 (first published: )

131 reads

Technical Article

HexToSmallInt

Hans asked if it could be faster. This is about 10% faster; not much. His is admittedly more readable, and mine will act very strangely with invalid hex digits.How does it work? I'm converting the string '1234' to the value 0x31323334 (for example), then subtracting '0000' so that it is 0-based in each byte (CONVERT(INT,0x30303030) […]

2005-05-16 (first published: )

91 reads

Blogs

Daily Coping 21 Oct 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

#PowershellBasics: Get a list of files from a directory.

By

I’ve got a project I’m working on at the moment and it includes a...

Join me next week at my first GroupBy session

By

2021 has been the year people want to learn about Temporal Tables, it seems....

Read the latest Blogs

Forums

Managed Instance, cross-database queries. What are the hidden requirements?

By ja_iris

Have a managed instance with 2 databases. In theory I should be able to...

Need the (default) port to connect - why is this not implicit.

By snomadj

So I have 2 instances (1 x 12, 1 x 19). Both have the...

Extract data from XML field

By SqlRookie

Hello, I have a SQL view with a column called GlobalCountryRegionXML. Here is an...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers