Category: Videos

Video – Improving SQL Server Performance by writing faster T-SQL Code- Sept 11, 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… Continue reading

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

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… Continue reading