Recently I got a very unique situation where I had to Remove All Query Cached Plans Not Used In Certain Period. Let us learn about that today.
SQL SERVER – Count NULL Values From Column
I have received a very simple but interesting question by one of my earlier clients about how to count NULL values from the column.
SQL SERVER – Top Reasons for Slow Performance
Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. Let us discuss this topic today.
SQL SERVER – Display Rupee Symbol in SSMS
Just instead of US Dollar Sign ($), they wanted to display it with Indian Rupee Sign (₹). Let us learn today how we can Display Rupee Symbol in SSMS.
SQL SERVER – SqlServerWriter Missing in vssadmin List Writers Command
After troubleshooting they found that when they run vssadmin list writers command from the command prompt, they are not seeing SqlServerWriter.
SQL SERVER – ISNUMERIC Function and Interesting Result
Let us learn, ISNUMERIC Function and Interesting Result. An interesting observation from my client of the Comprehensive Database Performance Health Check.
SQL SERVER – APPROX_COUNT_DISTINCT – Not Always Efficient
After a lot of testing, I figured out that the newly introduced function is not always efficient. A newly-introduced function APPROX_COUNT_DISTINCT.