Video – Improving SQL Server Performance by writing faster T-SQL Code- Sept 11, 2014 August 31, 2014 This webinar is now available for viewing online at any time. (About 60 Minutes)
Some of the concepts we will cover include:

Ways to find code that’s slow:

DMV’s like sys.dm_exec_procedure
SQL Profiler and Server Traces
Extended Events
Writing your own logging code. (My favorite but it’s a lot of work)


Why scalar and TVF functions are slow
Finding high use functions with … 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:
User-Defined functions (UDF) have been around SQL Server since the 2000 version. They are a great way to encapsulate business logic in a reusable form.  There are there types of … Read More