Videos

Videos

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)
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:

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)

 Functions:

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:
https://www.youtube.com/watch?v=OAdFQm7Pt-w
 
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