Let us learn about Memory Optimized in TempDB, which I had earlier discussed with my client Comprehensive Database Performance Health Check.
SQL SERVER – Enable Additional Logging for SQL Server Agent
When I searched for this topic, I was getting blogs where they were talking about additional logging for the job step in SQL Server Agent jobs.
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.
What are Different Methods to Know the Row Count of Table? – Interview Question of the Week #261
Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.
SQL SERVER – Heaps, Scans and RID Lookup
The question was do heaps are very bad and always force a table scan? Let us learn about RID Lookup, Heaps and table scan.
SQL SERVER Tools I Use and Recommend (Updated: January 2020)
Here is the updated list for January 2020 of all the tools which I recommend. Do let me know if you use any of the above tools.
SQL SERVER – Resolve WAIT_ON_SYNC_STATISTICS_REFRESH Wait Type
During Comprehensive Database Performance Health Check I recently faced a brand new wait type WAIT_ON_SYNC_STATISTICS_REFRESH.
SQL SERVER – Script to Find All Columns with a Specific Name in Database
Recently, one of the clients asked me if I have a Script to Find All Columns with a Specific Name in Database. Yes, of course, I do have it.
SQL SERVER – Always On Listener Failure – Provisioning Computer Object Failed With Error 5
I have written a few blogs on issues about the failure of listener creation in the cluster. In this blog, we will explore listener creation failure.
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.