We fixed the query performance by removing the bookmark lookup. Let us learn about that in today’s blog post, how we can fix this issue.
Identify Index Used for Query – SQL in Sixty Seconds #088
How do you identify index used for query? It is a popular question in my health checks, and this SQL in Sixty Seconds video shows the easy way.
Foundations of Document Databases with MongoDB – Video Course
I have recently build a Video Course at Foundations of Document Databases with MongoDB focusing on helping users to get started with MongoDB.
Stress Testing with oStress – SQL in Sixty Seconds #087
One of the things which we cover in my Comprehensive Database Performance Health Check is how to do Load Testing or Stress Testing with oStress.
Rebuild All Indexes for a Single Table – SQL in Sixty Seconds #086
Recently, while working with a client we ended up on a very interesting situation with a client where we had to Rebuild All Indexes for a Single Table.
SQL SERVER – Free Performance Tuning Videos
Let me share today some of the Free Performance Tuning Videos for SQL Server. Yesterday I wrote a blog post about COVID-19, Working From Home.
MariaDB Learning Path – Five Online Pluralsight Courses
I am indeed very delighted to share my suggestion about MariaDB Learning Path. Five video courses published on the Pluralsight.