@PaulWhite well, that was not the only bit to change. Not to mention that at some point the preferred way was not to show the [R]DBMS in the title (which might be subject to disagreement). It was also not the first such edit from the same user.
@dezso it seemed like a reasonable edit. if i knew you were also making edits i would have rejected it, but i don't think there's an indicator for that?
I just had to help coworker run a batch file that takes a while to execute, he asked how he'd know it finished (When he gets a new prompt obviously). Sheesh
I've got this query which used to take minutes to run and now takes like 6 seconds but it runs a thousands of time a day so I'd like to make it faster.
https://www.brentozar.com/pastetheplan/?id=B1MWfkuZ7
It seems that over 99% of the I/O during this query is happening on one clustered index sc...
I noticed that set-returning-functions has been made a synonym of functions. (Paul White♦, Sep 29 at 13:33, if I read https://dba.stackexchange.com/tags/synonyms correctly.
I am not too happy with this, since functions returning a set exhibit a family of problems distinct from plain functions an...