@ade_roe@matsonj This was my first thought when I read this. Looking at the plan should show Index Seek at first and then Table Scan on the second. All because the function in the WHERE clause makes the plan go from a set based operation to RBAR (row by agonizing row).
@MMarie I find it interesting that a lot of SM savvy people bought into a shitpost. He admits it in a comment. But people love to get offended and this is an effective demonstration.
@LowlyDba I just came across your scripts as I skimmed through dbatools commands. Sp_doc is just what I've been looking for. I used that along with VSCode to create nice html data dictionary files.
Great work!
@BrentO Thanks for sharing this Brent. My wife and I saw the video of the elderly Ukrainian woman offering the seeds and saying this to the invading soldier was inspiring. So glad to provide what little support I can. I ordered one as well!
@BrentO My morning started with our restore test instance telling me we had corruption in a primary finance database. Thankfully it turned out to be an issue with the backup on the storage device and not the database. A new Full backup resolved the problem.