filmov
tv
Make Your SQL Server Queries Go Faster by John Sterrett
Показать описание
Abstract:
Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? In this session, you will learn some T-SQL performance tuning tips that can be used on Monday back at the office. You will learn how to identify top offender queries, be able to benchmark queries. Finally we will cover 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.
Prerequisites: Experience building T-SQL Queries and the curiosity to learn how to tune your own queries.
About John
Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? In this session, you will learn some T-SQL performance tuning tips that can be used on Monday back at the office. You will learn how to identify top offender queries, be able to benchmark queries. Finally we will cover 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.
Prerequisites: Experience building T-SQL Queries and the curiosity to learn how to tune your own queries.
About John
0:05:57
0:04:13
0:04:08
0:01:24
0:03:18
0:10:04
1:37:51
0:09:00
0:12:07
0:16:36
0:44:57
0:06:43
0:08:37
0:17:40
0:02:23
0:24:25
0:08:33
0:12:53
0:02:38
0:00:33
0:00:22
0:04:45
2:45:17
4:03:27