T-SQL

Technical Article

HexToINT

  • Script

An optimized function for converting a HEX string into a INT. Built for being faster then other HexToDec converters.Slightly slower then HexToSMALLINT.If there is any faster function to do this conversion, I am intrested of using it instead.

You rated this post out of 5. Change rating

2005-05-04 (first published: )

298 reads

Technical Article

Optimized HexToSMALLINT

  • Script

An optimized function for converting a HEX string into a SMALLINT. Built for being faster then other HexToDec converters.If there is any faster function to do this conversion, I am intrested of using it instead.

You rated this post out of 5. Change rating

2006-10-11 (first published: )

126 reads

Technical Article

usp_KillUsers2

  • Script

This script expands on the usp_KillUsers script posted by Brian Knight, by adding the text of the process that is being killed and will even kill users who are accessing the database from with in a process of another database. Does not contain the NET SEND option though.

You rated this post out of 5. Change rating

2005-04-22 (first published: )

310 reads

Technical Article

Search for text in procedures (no cursors) UPDATE

  • Script

This is an update to the Search for text in procedures (no cursors) function (excellent script), which lists all of the objects (searching in syscomments, so it excludes tables). I have added a 2nd column to the output of the object type.

You rated this post out of 5. Change rating

2005-04-06 (first published: )

154 reads

Blogs

AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning

By

Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...

AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention

By

Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...

Flyway Tips: Multiple Projects

By

One of the nice things about Flyway Desktop is that it helps you manage...

Read the latest Blogs

Forums

Writing as an Art and a Job

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Writing as an Art and...

String Similarity II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item String Similarity II

Supervised versus Unsupervised Training of an Artificial Neural Network

By Stan Kulp-439977

Comments posted to this topic are about the item Supervised versus Unsupervised Training of...

Visit the forum

Question of the Day

String Similarity II

What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?

See possible answers