Getting back to consulting mode has got my newer clients and bigger challenges. Not only that I am seeing interests for some of the greatest and latest versions, but some clients are sitting on an older version of SQL Server requiring some serious help for trivial issues. One of my clients has asked to consult for a quick error message troubleshooting in the recent past. Since it was an interesting one about syspolicy_purge_history job, I am sharing it via the blog.
SQL SERVER – Management Studio – Changing Status Bar Location
To error is human and sometimes the errors / mistakes we make can easily put our jobs at stake. Such horror stories are something I keep hearing from people and they are super cool in a way because you learn from their experiences. In a recent corridor conversation with a friend, he said how cool he found my blog on: SQL SERVER – Color Coding SQL Server Management Studio Status Bar. He personally felt this was a cool thing. But he said even after that, it is sometimes difficult because the status bar location is at the bottom. I asked what is your screen resolution – he replied (2560 x 1440).
Interview Question of the Week #051 – Actual Execution Plan vs. Estimated Execution Plan
In one of the recent interview, I met quite a few interesting candidates. It is common for employees ask many questions during an interview, but there are times when candidates also ask questions back to the interviewee. I was asked following question recently.
Question: Do you use Actual Execution plan or Estimated Execution plan?
SQL SERVER – Getting to understand SQL Server Activity Monitor in SSMS
This site is flooded with blog posts around SQL Server Management Studio’s Activity Monitor capability. In fact, we have written few special case scenarios on how to use the same. In this blog post, I might not want to rehash the same, but take a stance on how I explained…
Read MoreSQL SERVER – Save and Send Execution Plan Via Email
Here is an interesting question, I received the other day. Hi Pinal, I have a very big graphical execution plan and I want to send it to my friend. My first thought was to send him query to execute on his own machine, but he does not have the same…
Read More
SQL SERVER – Trick – Running SSMS With Different Windows Account
Recently in one of my interaction with a DBA inside a big financial organization, I was surprised to see that the administrator was logging into a desktop / server using a different credential. What baffled me was the fact that he was logging off. I immediately asked, why are you…
Read MoreSQL SERVER – SSMS Query Command(s) completed successfully without ANY Results – Part 2
What do you do when you encounter something that you didn’t expect? A lot of times such experiences take you to a state of shock or a state of bafflement. The curiosity sometimes pushes you off the cliff to understand why certain behaviors occur. I am fortunate that I get…
Read More