Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

Query tuning for beginners

Sponsored · SiteGround - Reliable hosting with speed, security, and support you can count on. →
Avatar for vertora vertora
May 27, 2018
Programming
29
0

Query tuning for beginners

Query tuning for beginners

Avatar for vertora

vertora

May 27, 2018

Other Decks in Programming

See All in Programming
なぜCTOを降りてFDEを選んだのか？〜なぜプロダクト企業がFDEで顧客の現場に踏み込むのか〜
Avatar for ryuta sakamoto gonta
1
210
残高管理から台帳サービスへの進化
Avatar for kobaryo artoy
1
200
半永久的に提供し続けられるプライベートクラウドを目指して ― 利用者の認知負荷を抑えるAPI抽象化とハードウェア世代交代の基盤設計
Avatar for Tomofumi Kondo tomokon
0
500
UPDATE をやめる — EF Core でマスタをバージョン管理する
Avatar for HideyukiKitao panda728
PRO
0
1.2k
Agents on Rails - Rails at Scale 2026
Avatar for Irina Nazarova irinanazarova
0
560
contenteditable と日本語入力に向き合う
Avatar for taki colorful12
0
200
AWSに止められる覚悟してますか？
Avatar for モリゾー morizo_1984
2
530
設計次第でAIコードの読む量は減らせる / designing-for-code-reading
Avatar for MinoDriven minodriven
35
17k
When benchmarks go bad - what I learned from measuring performance wrong
Avatar for Holly Cummins hollycummins
0
220
最近”作らせてる” ローカルAIアプリの話
Avatar for ITO Akihiro akit37
0
470
AIに “答え“を書かせるのを やめてみた
Avatar for akari ___akari11
0
120
UnityでSystem.Net.WebSocketsなWebSocketサーバが動かないのでUnity Monoのコードを覗いてみた / about implementing websocket server with unity mono
Avatar for にー兄さん drumath2237
1
610

Featured

See All Featured
Mozcon NYC 2025: Stop Losing SEO Traffic
Avatar for Sam Torres samtorres
1
570
Faster Mobile Websites
Avatar for Dean Hume deanohume
310
32k
Tips & Tricks on How to Get Your First Job In Tech
Avatar for Honza Javorek honzajavorek
1
800
A brief & incomplete history of 
UX Design for the World Wide Web: 1989–2019
Avatar for Jason CranfordTeague jct
2
530
jQuery: Nuts, Bolts and Bling
Avatar for Doug Neiner dougneiner
66
8.6k
ピンチをチャンスに：未来をつくるプロダクトロードマップ #pmconf2020
Avatar for Aki / @LoveIdahoBurger aki_iinuma
128
56k
Building Experiences: Design Systems, User Experience, and Full Site Editing
Avatar for Michelle Schulp Hunt marktimemedia
1
630
Understanding Cognitive Biases in Performance Measurement
Avatar for Philip Tellis bluesmoon
32
3.1k
Leveraging LLMs for student feedback in introductory data science courses - posit::conf(2025)
Avatar for Mine Cetinkaya-Rundel minecr
1
440
We Have a Design System, Now What?
Avatar for Morgane Peng morganepeng
55
8.4k
Why Mistakes Are the Best Teachers: Turning Failure into a Pathway for Growth
Avatar for Umar Saidu Auna auna
0
320
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
Avatar for Kevin Liebholz kevinliebholz
37
6.6k

Transcript

  1. SQL Server Query tuning for beginners

  2. RANDI VERTONGEN SQL SERVER CONSULTANT @ KOHERA.SQL MCSA: SQL 2016

    DATABASE DEVELOPMENT sp_who2

  3. Contents of this session • Set based thinking • The

    query tuners toolbelt • Query tuning: the most common performance gains

  4. Set based thinking

  5. Your toolbelt

  6. Monitoring

  7. Demo

  8. Setting up your environment

  9. Tuning tools

  10. Start Tuning: Query adaptions

  11. None
  12. None
  13. None

  14. Demo

  15. None
  16. None
  17. None

  18. Start Tuning: Index adaptions

  19. Demo

  20.  Nocount  Xact_abort  Error handling

  21. Demo