Rob Volk

SQL Server DBA in the Metro Atlanta area, moves electrons for a living. I do deranged things in SQL Server...so you don't have to.

[Rob Volk @sql_r]

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: https://t.co/0Mq75UK0En #SQLFamily

[Rob Volk @sql_r]

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: https://t.co/0Mq75UKytV #SQLFamily

[Rob Volk @sql_r]

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: https://t.co/GU8ZJfPi2q #SQLFamily

[Rob Volk @sql_r]

@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!

[Simple Talk @Simple_Talk]

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.

[Andy Yun @SQLBek]

#SQLTrain 2024!

[Jeff Taylor @ReviewMyDB]

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

[Andy Yun @SQLBek]

Continuing the #SQLTrain tradition

[Rob Volk @sql_r]

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: https://t.co/M5fZYtRn0s

[Rob Volk @sql_r]

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: https://t.co/PJOPBLSCk9

[Rob Volk @sql_r]

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

[Rob Volk @sql_r]

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: https://t.co/PJOPBLSCk9

[Rob Volk @sql_r]

@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.

[Rob Volk @sql_r]

#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.

[Rob Volk @sql_r]

@SQLDBA @NikoNeugebauer @AnalyticAnna @GFritchey

[Rob Volk @sql_r]

@NikoNeugebauer @AnalyticAnna @GFritchey Sorry for the late reply, if you need a video: https://t.co/AsZRcDfjD8

And don't just limit yourself to spaces, there's a whole world of Unicode spaces available!

[Rob Volk @sql_r]

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

[Rob Volk @sql_r]

#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.

[Rob Volk @sql_r]

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

[Rob Volk @sql_r]

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

[Rob Volk @sql_r]

@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