Thank you!

Thank you for the explanation it's very useful. I was wondering if you meant Lost update in the example with Non-repeatable read instead? timestamp was 5:43

Hi Kendra, big fan of your presentation, Just say there wasn't "row level security limitation" and you get implicit conversion message how do you fix it? Is there a video or website it describes in detail thanks!

When I update a record and it turns into records because I get my where clause wrong, I use ALT+F4 to close my sessions, and ALT + P to print my resume.

I have the exact same problem on our SQL cluster and did not find this helpful I am sorry to say. All that and then "reboot", I thought there would be a process described on how to actually find the root cause and how to resolve.

The best video that I found on the topic.

Brings the question : how are isolation levels different from database locks?

Only theory is boring to listen...it would have been better if you show in practical. 😊

I got the script but I find out after searching for very long time. If you provided the script name that would be helpful. any way thanks for the wonderful video

why are you the best teacher? huh?

I have looked a several explation but yours is the simplest and the best! thanks!

Sometimes I wish that I work with you :)

The simplest, shortest and clearest presentation of the topic i have found so far. Thank you.

Invalid column name 'plan_forcing_type_desc'. why this appear ?

Really cute idea, but those are some odd examples compared to how you might normally see them used.

Hi Kendra... is there room to negotiate not signing that clause that states I am not allowed to work with a competitor?

Hi Kendra and Eric... On the topic of CTEs: I think I have to disagree with you, from a logical processing standpoint, on wanting TSQL to filter window functions within the same query. Because as a user, you're expected to think that filtering on rows is done first (where clause), then grouping (group by clause), then group filtering (having clause)... then at last, the select statement get executed ... so you really can't filter window functions in the where clause of the same query. Unless what you mentioned about snowflake does a CTE in the behind scenes .. which I'd argue isn't a helpful thing to nudge users to understand the processing aspects in the background. What do you think? :)

Very interesting video Awesome

thank you so much for this guide on how to think about optimizing a query!

you catalyze my sql

too much un nessary talks

For one line she wasted my 17 min. Shit these types of videos

Why don’t you add detail course for performance tuning or optimisation in sql server from basics

That was a great explanation, thanks 😊

Just found your content. Great content. 2024

Fun discussion to listen to. Miss you in Pdx Kendra. And thanks to Eugene, you have a great way of making some of the complex PBI concepts understandable. Thank you both.

Thnks, usefull. But <Shift> + <Alt> +Up/Down Arrow is more pratice insted of <Ctrl>+Mouse moving

Just watched this one again for the laughs. Thank you! We need more live Dear SQL DBA sessions!

Kendra attended the meeting with pyjamas?

👇 'promosm'

Very helpful, thanks

Very well explained, Thanks you!

What a great interview! Michael is an incredibly smart guy and was kind enough to answer my questions when I was starting with DB automation some time ago.

amazingly simple explanations of the very complicated subject. Thank you!

👍👍👍

The force is genuinely strong with these two. Much respect for their FORCE abilities, no pun intended 😆

STAR interview method has become very popular lately. e.g. Tell me about a time you resolved a performance problem/dealt with a difficult co-worker/failed miserably. Rather than, what's the difference between a clustered non clustered index? That one still weeds out a lot of the pretend DBAs though!

Hello Legends! :)

Why am I watching thumbnail sized images of you two having a discussion?

I remembered your article about wide indexing with hashbytes back in the day. I'm now a data engineer.

Good to see you back Kendra!

What is Pass? Also you look familiar from somewhere

Kendra Little you look great with long hair!

Hi Kendra, just happened to see your channel. Do you have any sql books recommended for newbies into sql developer career? Thank you.

How to fix this huge number of rows

Hello, Can we do a partial stats update like 20% or 50% on a table, if yes then please help with command