by Ian Bachman-Sanders | Aug 31, 2014 | SQL coding
I’ve written a new article on Indexed Views that has been www.DatabaseJournal.com As part of that article I included a UDF, udf_View_ColumnsIndexableTAB, that shows which columns in a view are eligible for indexing. It’ll be next week’s UDF of the...
by Ian Bachman-Sanders | Aug 31, 2014 | SQL coding
Indexed views are the topic of an article that I’ve written. It was published last week on DatabaseJournal. You can see it at: http://www.databasejournal.com/features/mssql/article.php/2119721 You probably got the special notice that I sent last week when it was...
by andrew novick | Aug 31, 2014 | Downloads, SQL coding
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...
by Ian Bachman-Sanders | Aug 1, 2014 | Problems Solved, SQL coding, SQL Performance
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...
by andrew novick | May 22, 2014 | Problems Solved, SQL coding, Uncategorized, Videos
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: User-Defined functions (UDF) have been around SQL Server since the...
