1 DBA's Professional Blog
Enabling the scrollbar map has saved me oodles of time – even without the preview option enabled. I can much more quickly hop to different segments of code with this feature than I could if trying to scroll up and down trying to find that one little section I need.
Some view the permissions for Extended Events as a limitation. I see the required permissions as an appropriate set and recommend all to work with XE and permissions to provide higher efficiency to their environment.
Despite it being new, it seems there are a handful of “facts” already published about it that may or may not be accurate. Due to that, I want to play a little game of fact or fiction with it in this article.
If an application vendor has something built into their code to perform index maintenance, unbeknownst to you, that is a near-worst case scenario.
If you are not progressing, you are regressing. In the same vein, if you are not learning, you are regressing.