Office Hours: Ask Me Anything About SQL Server, Puffin Edition

00:00 Introductions
01:43 Should developers create indexes for their queries?
03:28 Do you recommend monitoring for resource-intensive queries?
04:40 How should I set max server memory?
07:30 How much free space in buffer pages is acceptable?
09:42 How can I fix implicit conversion in a 3rd party app?
11:55 How do you organize tasks for productivity?
14:00 How do you manage your mental state for productivity?
16:02 Why might too many indexes slow down selects?
18:00 What's better - queries in the app or in stored procedures?
22:06 How do I prioritize DBA tasks?
23:38 How do I find which queries are winning the deadlocks?
24:35 How do I find out what my memory is being used for?
26:10 Wrap-up
27:40 Walking you over to the puffins

[floginvids]

The Icelandic department of tourism should be sponsoring these videos.

[DanielMaenle]

Thank you for all you do for the community, and answering questions.

[DarkJiggly]

SQL Server questions near sea birds & the Arctic Circle, a little bit...alienating ^__^ Thanks for this amazing view (and for educating Puffins about SQL Server issues)!

[stockburn]

Thanks again Brent, loving the scenery and SQL advice.

[larrydugger]

Once again a most excellent host, informative, visually pleasing, and a nice start to the day, thanks Brent. 🤙

[BrandonChampion]

"THE HELL I DID! I QUIT!"
I'm loving these Icelandic videos. Thank you, Brent.

[christopherblack]

Thank you again. I do the same thing with work. I try to timebox my activities and quit when it is time. Lots of good info.

[thomasfranz]

Regarding the indexed views:
Is there a trick that let SQL Server (2016 SP2 Enterprise in my case) use them WITHOUT specifying the WITH(NOEXPAND) hint after the view name? Whenever I tried to use indexed views SQL Server did still use the basic table, even if the view is indexed much better / would cause less reads.

[markuspersson]

love these outdoor sessions!! how often will you do them?

[thele]

Index a view? Wouldn't that be a materialized view? Doesn't that eliminate the realtime nature of views (since materialized would be a snapshot in time)?

[gversluis]

Another great video, thanks! Made me realize once again to start using my learning pass. 😬
The birds actually remind me of bad project managers aka seagulls... the ones that fly in screaming, dump all over the place and then fly off screaming again 😁

[Algedibarrios]

Thank you Brent! What advise can you give me if I want to relaunch my career as programmer successfully after 9 years because of Burn out Syndrome and how can I focus in an objective with so many new technologies there outside without to feel overwhelmed in a world with many programmers much than me?

[cjmorgan]

Sounds like the Kill Deer here in Idaho...they gather in groups of 3 or 4 and just "yell" at each other in the most annoying screechy voice. They don't dive bomb thankfully!

[mjswart]

Some advice you gave was “Search for ‘Brent Ozar Hierarchy of Needs’’”
I knew that was coming before you said it. Although I guessed that it was going to be “Brent Ozar You need to poop”

[TheColjackoneal]

I thought Brent was going to announce he's blind

[Dmitriy.]

"Puffin edition" sounds more like "after-office hours."