Rob Volk

Last call! SQLTrain 2025 registration is open until November 9! If you are attending #SQLSaturday Oregon/Washington and traveling to #PASSDataCommunitySummit, why not take the train? #SQLTrain2025 is here: eventbrite.com/e/sql-train-20… #SQLFamily

There's still time! SQLTrain 2025 registration is open until November 9! If you are attending #SQLSaturday Oregon/Washington and traveling to #PASSDataCommunitySummit, why not take the train? #SQLTrain2025 is here: eventbrite.com/e/sql-train-20… #SQLFamily

SQLTrain 2025 registration is open until November 9! If you are attending #SQLSaturday Oregon/Washington and traveling to #PASSDataCommunitySummit, why not take the train? #SQLTrain2025 is here: eventbrite.com/e/sql-train-20… #SQLFamily

@ReviewMyDB @SQLBek @SQL_JAR @Simple_Talk @drsql Thanks everyone for joining #SQLTrain in 2024! Thanks @Simple_Talk for making this year even better! See you next year!

All aboard!! #SQLTrain #SQLFamily @sql_r @SQLBek @SQL_JAR thanks to @Simple_Talk and @drsql for sponsoring!

If you have never heard of #SQLTrain, it is a very economical way to meet several of the big names in the Microsoft Data Platform world. It travels from Vancouver WA (US) to Seattle on the Sunday between the SQL Sat event held in Vancouver and Seattle.

#SQLTrain 2024!

Continuing the #SQLTrain tradition

SQLTrain 2024 registration is open until Oct. 26! If you are attending #SQLSaturday Oregon/Washington and traveling to #PASSDataCommunitySummit, why not take the train? Now with Awesome Sponsorship from @Simple_Talk! #SQLTrain2024 is here: eventbrite.com/e/sql-train-20…

SQLTrain 2024 is now live! If you are attending #SQLSaturday Oregon/Washington and traveling to #PASSDataCommunitySummit, why not take the train? Hang with cool people! See the landscape! #SQLTrain2024 Tickets and details are here: eventbrite.com/e/sql-train-20…

@getwired Which is recursive, as Michael Crichton was inspired by Disneyland animatronics when he wrote Westworld :)

@AngryPets Thanks for suggestions. I was also bummed the job tokens didn't cover it. I got the impression that it's not accessible from the SQL process space, but only SQLAgent exec. Every attempt at introspection within the job yields nothing. No XE either.

@sql_r Hopefully, me saying "I don't think it can be done" will inspire someone to prove me wrong and Rob'll get the answer he's looking for ;) This is a fun enough question though. SOMETHING in the job engine is keeping tabs on this. Just don't think it's surfaced until END of job.

#sqlhelp Is there a way for a SQLAgent job step to know which schedule started the job at runtime? I know it's logged in the history, but can't tell if it can be determined while running. Thanks.

@SQLDBA @NikoNeugebauer @AnalyticAnna @GFritchey

@sql_r @NikoNeugebauer @AnalyticAnna @GFritchey Rob, you were the first person that came to mind when I saw Anna tweet this. 😆

TIL you can have spaces in database names 🤯🤦🏽‍♀️

@NikoNeugebauer @AnalyticAnna @GFritchey Sorry for the late reply, if you need a video: youtube.com/watch?v=qI7YzT… And don't just limit yourself to spaces, there's a whole world of Unicode spaces available!

@AnalyticAnna @GFritchey @sql_r

@sqlstudent144 I was hoping there was an overlooked column or function somewhere that I, well, overlooked.

@sql_r If you already have to shred it why not shred the plan type as well?

#sqlhelp is there an easier way to determine if a query plan is trivial, other than shredding the plan xml? Query Store isn't an option unfortunately. Thanks.

@sqlstudent144 Well there's other things I need to look for, plus comparing plan elements programmatically. Text shredding is bit fussier.

@sql_r You'd have to be mad to shred XML if you don't have to. 😛

@erikdarlingdata ¡Gracias! I was working on a similar query, appreciate the timesave.

@sql_r There's a check for that in BlitzCache, if you want to make life a little easier: #L3060" target="_blank" rel="nofollow noopener">github.com/BrentOzarULTD/…

@sqlstudent144 Yeah, that's on option, and it should be fast enough. It just wouldn't show off my mad XML shredding skillz. Plus the 10K plans I have to search

@sql_r If all you want to do is to see if it's specifically trivial couldn't you just do a pattern match on the XML? It won't be super fast but faster than shredding the XML properly.