by andrew novick | Aug 31, 2014 | Past Events, Presentations, SQL Performance, Talks and Seminars, Videos, Webinars
This webinar is now available for viewing online at any time. (About 60 Minutes) http://www.mssqltips.com/sql-server-video/332/proving-sql-server-performance-by-writing-faster-tsql-code/ Some of the concepts we will cover include: Ways to find code that’s slow:...
by andrew novick | Aug 20, 2014 | SQL Performance
The SQL Profiler is a great tool for monitoring and analyzing SQL Server Performance. I use it all the time to watch the detailed actions of a stored procedure, trigger or user-defined function (UDF) that I am developing. It can also be used to monitor aggregate...
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...
