Dan Maenle's Avatar

Dan Maenle

@danthesqlman

Principal consultant of Maenle Data Consulting. Sr. Data Management Specialist at Black Diamond. World traveler. Saving the world one SQL Query at a time

31
Followers
20
Following
14
Posts
16.08.2023
Joined
Posts Following

Latest posts by Dan Maenle @danthesqlman

I like it

12.04.2024 09:26 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Oh I didn't say mine was interesting. But it's a book I could do

01.04.2024 13:58 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

An autobiography

01.04.2024 00:25 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 2 ๐Ÿ“Œ 0

Really enjoying my options here in the Philippines. Had to get a chest x-ray recently. No insurance. I paid 6$. This also included the reading and evaluation.

We are getting coverage. Premium is 3000$ a year. For myself,wife and son. With maximum payout of 2million per person

13.01.2024 07:53 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

And only would show up when running lots of concurrent versions? What could be ways around this?

31.10.2023 23:50 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Yeah we get floods of new plans and qs can't keep up. We hit plan cache super hard here. Doesn't last more than 6 hours

31.10.2023 13:12 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

That's what I was afraid of. Due to this I can't use query store. It hoses it

31.10.2023 10:00 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

Trying to figure out why this happens.
Reviewing a clients queries, and seeing the temp tables coming across as
[#Ids_91b0ea41_840d_416d_832e_10042060f91e]
Instead as just [#Ids] not sure what is adding the extra characters.
Not even sure how to research this. #sqlfamily

31.10.2023 08:43 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 3 ๐Ÿ“Œ 0

I'm trying to follow people on the Mssql data platform.
If you know of others here please tag them.

19.10.2023 12:15 ๐Ÿ‘ 2 ๐Ÿ” 0 ๐Ÿ’ฌ 2 ๐Ÿ“Œ 0

I always enjoyed the lesson on how the stuff I own ends up owning me. And thus have adopted a more minimalist lifestyle. But I don't need to fight other guys to learn that.

20.09.2023 13:20 ๐Ÿ‘ 2 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

One of the funniest things I have seen in a while.

guthib.com

20.09.2023 13:19 ๐Ÿ‘ 3 ๐Ÿ” 2 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Having CE model 130 issues. Database is in compat mode 150 no query hints. But the ce model used by queries is 130 on execution plans. I don't see any trace flags running. Not sure what can be going on #sqlhelp
SQL2019 enterprise

29.08.2023 03:33 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

Good morning to all.
Working toward many exciting things while handling the sad and craziness as well.

16.08.2023 16:13 ๐Ÿ‘ 4 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

Watch out for scope creep as well.

16.08.2023 16:10 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0