Watch Brent Tune Queries - SQLSaturday Oslo

No video

Watch Brent Tune Queries - SQLSaturday Oslo

Рет қаралды 44,651

Brent Ozar Unlimited

Күн бұрын

Пікірлер: 44

@Randomvideofanatic 3 жыл бұрын

There are very few people who could make query tuning enjoyable and entertaining... you, my friend, are one of them! Thank you so much for the information and providing it in an easily memorable way.

@BrentOzarUnlimited 3 жыл бұрын

Wow, thank you!

@Amy-ve3ke 2 жыл бұрын

Quickest video I’ve watched in one hour ?! Can’t believe how much I enjoyed this

@killo4life Жыл бұрын

So enjoyable to watch omg I was tuned in for the entire video understanding everything 100%. You have a wonderful gift

@montro2220 10 ай бұрын

Very good video, I love it presenters say that they are terrible at presenting (me being one of them) and they make the best presentations 😆

@BrentOzarUnlimited 10 ай бұрын

Thanks for that!

@georgekopadze791 8 ай бұрын

You are really good presenter and explain clearly what you want us to understand. Well done, I appreciate your effort and please keep doing. Especially advanced topics: optimization, sharding, indexes and etc. thank you

@BrentOzarUnlimited 8 ай бұрын

Thank you very much! You'll enjoy my training classes where I cover those advanced topics. Go to BrentOzar.com and click Training at the top of the page.

@informationtechnology6001 2 жыл бұрын

Really nice rep I did not feel boring thank you so much and hope to see new videos

@BrentOzarUnlimited 2 жыл бұрын

Sure, check out my channel. I have several new videos a week. Cheers!

@Bill-et5sk 2 ай бұрын

So good I watched it twice.

@Pastryarchy 4 жыл бұрын

Thank you for this I'm being destroyed by an app at work and this has given me a lot of things to try

@MiningForPies Жыл бұрын

Did you get it sorted

@ZafarIssadeen 3 жыл бұрын

You’ve got a great Liam Neeson impression going!

@MiguelNoyaTeixeira 2 жыл бұрын

You’re great…Learned a lot today!

@danielcraig9349 Жыл бұрын

Very helpful video, though the sound effects and talk of weed over my speakers at work was less than professional..lol

@BrentOzarUnlimited Жыл бұрын

Goodness! Best to stay clear of my other videos, then. I'm not boring, for sure, heh.

@function888 6 ай бұрын

Thank you again, that was wonderful to watch!! BTW, can we get the SP to complete in less than 29 seconds on this hardware??

@BrentOzarUnlimited 6 ай бұрын

Check out my Mastering Query Tuning class where you can learn techniques to help.

@devarakondasankararao3802 10 ай бұрын

The great video sir , thank you

@BrentOzarUnlimited 10 ай бұрын

You are welcome

@titusm9837 9 ай бұрын

Soooo what was the right answer?:)))) option recompile? so at least for other locations it would work fast?

@shabeenakhoja4776 3 жыл бұрын

Super helpful, thank you!

@keb777 2 жыл бұрын

"I have 5 fingers on this hand and 5 fingers on that hand" - that's suprising)

@voltairend 2 жыл бұрын

Excellent

@michaelsowemimo2405 Жыл бұрын

Skeet Skeet...im sorry i couldnt help myself :P

@user-zf6sl1lv1c 3 жыл бұрын

Thanks!

@andrewp7497 3 жыл бұрын

So no solution!....emmmm O

@peterlucas5634 3 жыл бұрын

I think the query was designed to be horrible. There are lots of solutions though, my attempt is below. CREATE OR ALTER PROC dbo.rpt_TopUsers_ByLocation @Location NVARCHAR(100), @StartDate DATE, @EndDate DATE AS BEGIN create table #Score (UserID int primary key clustered, PostScore int ) insert into #Score(UserID, PostScore) SELECT u.Id, SUM(isnull(p.Score, 0)) AS PostsScore FROM dbo.Users u LEFT OUTER JOIN dbo.Posts p ON u.Id = p.OwnerUserId AND p.CreationDate BETWEEN @StartDate AND @EndDate WHERE u.Location = @Location GROUP BY u.Id select u.Id, u.DisplayName, u.AboutMe, s.PostScore, SUM(c.Score) AS CommentsScore from dbo.Users u join #Score s on u.Id = s.UserID left join dbo.Comments c ON u.Id = c.UserId AND c.CreationDate BETWEEN @StartDate AND @EndDate group by u.Id, u.DisplayName, u.AboutMe, s.PostScore order by s.PostScore desc END GO

@VegasJPH 2 жыл бұрын

That clippy voice... 😂😂

@justsidu 10 ай бұрын

This video could've been 10minutes. Needs a performance optimization

@BrentOzarUnlimited 10 ай бұрын

By all means, feel free to release your own! I'd love to see it.

@Ulmenos 9 ай бұрын

soooo are we unable to do anything to statistics to improve the estimates?

@BrentOzarUnlimited 9 ай бұрын

We have a whole class on that! Check out the free Statistics class on our KZfaq channel.

@coreymagin 3 жыл бұрын

I love you man.

@BrentOzarUnlimited 3 жыл бұрын

Hahaha, thanks!

@mehdighapanvari9950 2 жыл бұрын

Please review your procedure, many thanks.

@hnbright Жыл бұрын

wouldn't it be better to create a stats table where the counts are kept updated, instead of calculating it every time through this query?

@BrentOzarUnlimited Жыл бұрын

I'll rephrase your question and see if I understand right: "If I have a slow query, wouldn't it be better to add new tables with the results, keep the results up to date, and then query those new tables instead?"

@hnbright Жыл бұрын

Yes. Although I am totally intrigued by this demo and would try out the same on my sandbox soon.