What To Do When SQL Server is Slow Brent Ozar

preview_player
Показать описание

Links to PASS and our Site:

Use our discount code VGDISM843 to save $150.00 off the full price of PASS

  1. DBAFundamentals
  2. sql
  3. brent ozar
  4. sql server
  5. performance
  6. checklist
Рекомендации по теме
SQL Explained in 0:02:23

SQL Explained in 100 Seconds

you need to 0:24:25

you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)

What is SQL? 0:04:26

What is SQL? [in 4 minutes for beginners]

What is SQL 0:03:19

What is SQL | SQL Explained | SQL in 3 Minutes | Intellipaat

SQL Server Tutorial 0:09:51

SQL Server Tutorial - One-to-many and many-to-many table relationships

SQL Tutorial for 0:44:57

SQL Tutorial for Beginners

Learn Basic SQL 0:17:40

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

MS SQL DBA 1:01:40

MS SQL DBA Online Training | Batch 1 | 6th AUG 2024 | Day 4

Do THIS instead 0:08:10

Do THIS instead of watching endless tutorials - how I’d learn SQL FAST in 2024

What Is SQL 0:02:39

What Is SQL Injection?

What is SQL? 0:06:12

What is SQL? Future Career Scope & Resources

SQL Tutorial for 3:10:19

SQL Tutorial for Beginners [Full Course]

5 Basic SELECT 0:06:43

5 Basic SELECT Statement Queries in SQL

How I use 0:15:30

How I use SQL as a Data Analyst

SQL Query Optimization 0:03:18

SQL Query Optimization - Tips for More Efficient Queries

SQL Tutorial - 4:20:39

SQL Tutorial - Full Database Course for Beginners

How do SQL 0:12:12

How do SQL Indexes Work

SQL Certifications for 0:02:21

SQL Certifications for the Data Analyst

Cursors in sql 0:13:58

Cursors in sql server Part 63

How to learn 0:27:20

How to learn SQL for free | Roadmap to learning SQL

How is data 0:07:04

How is data stored in sql database

Microsoft Power BI 0:02:38

Microsoft Power BI | How to get data from SQL server? | Tutorialspoint

I learned SQL 0:04:10

I learned SQL for data analytics in 15 days | From Scratch

Комментарии
Автор

High quality content! Useful. Trying out the blitz scripts now.

captainnemonic
Автор

What an absolute gem of a video! Many thanks

jerrycons
Автор

Great video, you do make learning fun, Brent!

flyingcod
Автор

Very helpful, fantastic stuff.. thanks Brent Ozar..

foodiegowda
Автор

29:44 - LOL! This is why I like watching Brent.

RIDDLEMASTER
Автор

Only Brent can make this topic as hilarious as he does.

jacobcase
Автор

I JUST GOT INDEX CLASES OM YOUR WEB SITE IS AMAZING
GOOD LUCK BRENT

tahreb
Автор

Brent I love your presentation, clearly you know what and what not to do. Your presentation really follows what a DBA must follow in order to, dictate the problem, minimize risks, but more importantly, look after your back and follow process of the enterprise. This is all great and much appreciated, however, I imagine you have some dirty and risky tricks prior to hitting that rollback button. So per as your example, a change was made by Norm, with no Commit, tequilas ruined. Could you please confirm if the following would work: 1) Alter SPROC in replica 2) Change connection strings on client to REPLICA 3) Let roll back complete, replication should prevent data loss ... would this prevent DATA loss and high availability ?

richardvazquez
Автор

Sir u r amazing....A legend to be exact!!!!

owaisqamer
Автор

Great video... Enjoy the IT / DBA humor.

Utini_
Автор

In the example, with Norm's begin transaction without a commit which caused the blocking, could a situation like that be resolved with Norm committing the transaction? Wouldn the other queries then be free to access the tables blocked by the transaction? Or am I missing something?

safraz.hosein
Автор

38:32 so true. Microsoft Office/Visio/OneNote can never agree on whether or not my licenses are valid. Thank goodness SQL Server has a different authentication system - but then again, that's a whole different kind of wacky-ness.

bebeting
Автор

I'm studying to be a jr DBA so pardon the newb question here but why are the log files continuing to grow? What is being recorded during this stalemate of Norm's uncommitted transaction?

ulysses
Автор

Ur videos make sql from poison to cool drinks

shaikzuhair