Hopping back on here to say:
@MattMcgiffen ... TDE... thank you 🙏
Limerick, Ireland 🇮🇪 English
Shane O'Neill
9.8K posts
Shane O'Neill
@SOZDBA
He/Him. DBA. Automation. Food, Coffee, Whiskey (not necessarily in that order)... @[email protected]
Ireland เข้าร่วม Şubat 2009
2.2K กำลังติดตาม1.4K ผู้ติดตาม
Dice and Desire – I enjoyed every one of the 790 minutes I spent with you in 2023. Thank you. #SpotifyWrapped
open.spotify.com/show/2TL45R0Df…
Limerick, Ireland 🇮🇪 English
Based on the number of connection requests I received today and yesterday, I assume people are talking during the PASS Summit.
I can only say thank you; the stories are grossly overestimated in my favour.
English
First #blog back in a while - to do with #PowerShell and Read-Host
nocolumnname.blog/2023/10/10/ini…
English
My #tsql2sday post is up just before the deadline:
nocolumnname.blog/2023/07/11/t-s…
Thanks for hosting @erikdarlingdata
#sqlblog
English
I've decided to highlight blog posts that have helped me out when they help me out.
Rather than just read, action, then forget.
So thank you @Kendra_Little for your post on "NO_PLAN and NO_INDEX: Breaking a Forced Query Store Plan"
littlekendra.com/2016/03/25/no_…
#SQLServer
English
Thanks to all at #DataCeili. Sorry, I have to head off early, but I'm looking forward to catching up with you all again!
Dublin City, Ireland 🇮🇪 English
Dublin City, Ireland 🇮🇪 English
English
@SOZDBA If I've read through this correctly, @PaulRandal bogged this back in 2010 and this comment in 2019 could indicate it may still not be fixed:
#comment-1169121" target="_blank" rel="nofollow noopener">sqlskills.com/blogs/paul/mis…
English
#SQLServer challenge for anyone who likes figuring things out.
I've created the index it asked me to.
Run the query again, and it suggests the same index
**even though it uses it**
I can replicate but I can't figure out why.
Anyone want to try to replicate it? 😇😈
English
Final trick, and thanks to those that responded, I now know more than before.
I can only replicate this with these conditions:
1. FULL optimization
2. Range comparison on 1 of the columns,
3. Partitioned table (Yes, I was sneaky and didn't mention this)
English
Not sure if this is a hint, but the issue is only present when the query goes through Full Optimization.
When it's Trivial Optimization, no missing index shows, and the query uses the index fine.
That's why I had to add
AND (SELECT 1) = (SELECT 1);
to the WHERE clause
English
@feaselkl @sqL_handLe And why SQL Server suggests the index that already exists, and the one it uses, when a range is supplied
English
@feaselkl @sqL_handLe Interesting, the range could be something to do with it.
Changing the range to an equality does change the order.
When that index replaces the order one, no missing index recommendation shows
(must read that link fully to try and figure out why)
English