Webinars

Webinars

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