Videos

Generating T-SQL with AI, a quick demo on YouTube

Apr 17, 2025

The YouTube video by Andy Novick demonstrates using a large language model (specifically Grok-3 in April 2025) to generate T-SQL code for a simple ETL task. Novick, a SQL Server consultant, provides a scenario involving moving data between two similar tables with…

Video – Improving SQL Server Performance by writing faster T-SQL Code- Sept 11, 2014

Aug 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…

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

“Software performance was our single biggest problem. We did everything we could do in-house to get the database running like it should and really needed some help. You quickly pinpointed problem areas and your setup, index and query recommendations greatly improved the software’s performance.”

Daniel J. Mc Intyre, Vice President
Management Computer Services, Inc.

Videos

Generating T-SQL with AI, a quick demo on YouTube

Video – Improving SQL Server Performance by writing faster T-SQL Code- Sept 11, 2014

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

Upcoming Events

Latest SQL Tips:

Loading SQL Profiler trace (.trc) files into a table

Problem Solved:

Level 16 Errors Can’t always be handled by User Code