GroupBy – Free SQL Server Training   /     Make Your Own SQL Server Queries Go Faster by John Sterrett

Subtitle
Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? I know I did. It is how I stumbled into my career in performance tuning.  In this session, you will learn some T-SQL performance tuning...
Duration
01:03:28
Publishing date
2018-10-16 10:00
Link
http://groupby.libsyn.com/make-your-own-sql-server-queries-go-faster-by-john-sterrett
Contributors
Enclosures
http://traffic.libsyn.com/groupby/GroupBy068.mp3?dest-id=448922
audio/mpeg

Shownotes

Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? I know I did. It is how I stumbled into my career in performance tuning.  In this session, you will learn some T-SQL performance tuning tips that can be used in the office immediately. You will learn how to identify top offender queries, be able to benchmark queries. Finally, we will cover some coding patterns that are developer friendly but are not SQL Server database engine friendly and show you how to rewrite them so they can run faster.