HexToINT

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.

Optimized HexToSMALLINT

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.

What is the new method of error handling...

Which of the following select statements will produce...

usp_KillUsers2

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.

What does this do?

SELECT getdate()
WHERE getdate() > getdate()-1
OR getdate()-1...

Given type-compatible relations T1 and T2, which of...

Given type-compatible relations T1, T2, and T3, which...

Search for text in procedures (no cursors) UPDATE

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.

In the following SQL query:


SELECT a, b, c
FROM...