Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
If you’ve upgraded your SSMS lately, you might have seen this. Queries now have a completion time on the Messages window.
On one hand, I think this is great, because I can tell that I’ve run this recently. On the other hand, I might have multiple batches, so I can get confused or mis-informed. I also just don’t like this.
Microsoft didn’t agree, because at first, I couldn’t remove this. That was really annoying. However, with SSMS v18.3.1, I can.
If I go to the SSMS Options, and then go to Query Execution | SQL Server | Advanced, I see this:
At the bottom of the first column is the Show completion time checkbox. Uncheck this, and suddenly, I’m happy.
One caveat, I do need to open a new window. That old window, even if I change the connection, still shows the time. Fortunately, CTRL+A, CTRL+C, CTRL+V help me move on.
This was one of those annoying things I needed to fix because it impacted my productivity. It’s a perfect post of my finding a way to be more productive and learning on my own.