Category: Current Event

Writing Faster T-SQL Stored Procedures and Functions: Lessons Learned

Stored procedures and functions are the mainstay of SQL Server coding. This presentation will show techniques to improve their performance. Continue reading

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