Shane O'Neill
@SOZDBA
Followers
1K
Following
20K
Media
1K
Statuses
10K
He/Him. DBA. Automation. Food, Coffee, Whiskey (not necessarily in that order)... @[email protected]
Ireland
Joined February 2009
Dice and Desire – I enjoyed every one of the 790 minutes I spent with you in 2023. Thank you. #SpotifyWrapped .
open.spotify.com
Podcast · Dice and Desire · Six friends go adventuring in this actual play Dungeons and Dragons 5e podcast. Listen to find out how they avoid a TPK this week! New episodes every Wednesday.
0
0
0
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.
0
0
8
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". #SQLServer.
kendralittle.com
Whenever you’ve got a new feature, one of the first things to ask is, “What happens when I break it?” Because we’re going to break stuff.
0
0
3
Thanks to all at #DataCeili. Sorry, I have to head off early, but I'm looking forward to catching up with you all again!.
0
0
2
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).
0
0
0
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.
1
0
0
cc @jodouglass 😇.
@PAH66 Thankfully it's a small enough index that I can try all the different orderings. All of them lead to the same "use this index" and all the recommended indexes come back as the same column1-created_date-column2 order. So, index column order doesn't seem to matter so far
0
0
0
#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? 😇😈
5
1
2