After the blog posts about temp and regular table, I have received questions about it hence I am writing this blog post about TempDB Logging.
SQL SERVER – Regular Table or Temp Table – A Quick Performance Comparison
What is more optimal for the data load – Temp Table or Regular table? Why? The question was very simple but interesting one and I have decided to answer.
SQL SERVER – Check for Update in SSMS
DBAs and Devs had many interesting questions during the Comprehensive Database Performance Health Check. How to check the update in SSMS?
SQL SERVER – Brief Note About RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Type Resource
Today we will see Brief Note About RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Type resource. I wrote a blog post about Enable Lock Pages in Memory LPIM.
SQL SERVER – Enable Lock Pages in Memory LPIM
In this particular case, we had memory issue and after careful investigation, we found the troublemaker as a Lock Pages in Memory settings.
How to List All DML Triggers Created or Modified in the Last N Days in SQL Server? – Interview Question of the Week #242
Question: How to List All DML Triggers Created or Modified in the Last N Days in SQL Server? Let us see the answer of this question in this blog.
September 2019 Trainings – 21 Essential Scripts: Performance Tuning
I will be delivering four classes on my most popular training on 21 Essential Scripts: Performance Tuning in Europe in the month of September 2019.Â
MySQL Preferred Engine – MyISAM or InnoDB
Most of my time is spent with my clients on the Comprehensive Database Performance Health Check. MySQL Preferred Engine – MyISAM or InnoDB
SQL SERVER Management Studio 18 – Enable Dark Theme
We are all techies and we love to use a dark theme in our IDEs. I get quite often a question about how to enable dark theme in SQL Server Management Studio.
Understanding State of SQL Server Monitoring 2019 Report
Earlier Red Gate launched the industry’s first-ever report into the state of SQL Server monitoring. Recently they released Report for the year.