SQL Coding

Transact-SQL User Defined Functions – PDF available for free

Aug 31, 2014

It was written quite a while ago but if you’re starting out using functions in T-SQL, it’s still a good resource. Except for the section on system UDFs the rest of the book remains correct. There just haven’t been that many changes in how functions work since SQL…

read more

Retrieving a Random Record in SQL Server using udf_Num_RanInt

Aug 1, 2014

This UDFs week solves a problem posed to me last week by a friend Gary.  Gary wants to select a random row from one of his tables and was hoping that SQL Server would have some support for this task. The idea of selecting a random row runs counter to the ideas that…

read more

The Problem with User-Defined Functions (UDF) and a Solution

May 22, 2014

Download the sample script: Problem-Scalar-UDF-and-solution-andy-novick   and a PDF of the slides: The Problem with scalar UDFs and a solution – Andy Novick Or watch the video on Youtube: https://www.youtube.com/watch?v=OAdFQm7Pt-w   User-Defined functions (UDF)…

read more

“Software performance was our single biggest problem. We did everything we could do in-house to get the database running like it should and really needed some help. You quickly pinpointed problem areas and your setup, index and query recommendations greatly improved the software’s performance.”
Daniel J. Mc Intyre, Vice President
Management Computer Services, Inc.

Upcoming Events

> See All Events