August 2021 - Make Your SQL Server Queries Go Faster by John Sterrett (@JohnSterrett)
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
John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQL Saturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John's community activities can be found at https://johnsterrett.com/community/
-
1:03:14
Los Angeles Data Platform
3 years agoOctober 2020 - SQL Engine: Its Working Style by Deepthi Goguri (@dbanuggets)
12 -
59:32
Data.SQL.Saturday.LA
2 years ago2021 Data.SQL.Saturday.LA presents: Lightning-fast processing in a SQL Server
10 -
0:44
Pharos Technology
11 months agoImprove Your Report Response Time by Creating a Table from your Query
4 -
11:47
Pharos Technology
10 months ago $0.01 earnedSubqueries: Streamlining Your Database Processes
9 -
11:02
Pharos Technology
10 months agoUnderstanding SQL Fundamentals in Microsoft Access
4 -
17:05
itmadesimple
10 months agoMaster SQL Aggregate Functions: Beginner's Guide
14 -
12:47
Pharos Technology
4 years agoReduce Data Access Time Through Efficient Query Processing
-
5:28
TechWithMartin
1 year ago $0.01 earnedMaster SQL for Beginners Part 1-Connect to server
41 -
2:21:31
Nate_Stakes
1 year agoCoding at Harvard CS50 2022 - Lecture 7 - SQL : Staked Up!
5 -
30:12
CodeWithYu
7 months agoDBT and BigQuery Beginners Crash Course in 30 minutes
13