Today we will see a very simple script that lists table names with the size of the table and along with that row counts. Let us learn it in today.
MySQL MariaDB – Query Using Temp Table
SQL Server Performance Tuning but this time the question was more related to the MySQL installation they had in their system. Query Using Temp Table.
SQL SERVER – Check Backup Reliability
Recently I was asked by one of my clients of Comprehensive Database Performance Health Check recently asked if there is any way to Check Backup Reliability.
SQL SERVER – Finding Fragmentation in Forwarded Records
I was asked by my client if there any way to know if there is any way of Finding Fragmentation in Forwarded Records. Let us learn in today’s blog post.
SQL SERVER – Who Dropped Table? Part 2
There is a way to find out few more things. However, before we continue I strongly suggest that you watch the following video about the dropped table.
Build Your First Data Visualization with Epoch – Pluralsight Course
FusionCharts is a very effective way to represent visualizations. I have to build a course – Build Your First Data Visualization with Epoch.
Practical Real World SQL Server Performance for Everyone – 2021 Edition
This is a one-time opportunity to sign up for Practical Real World SQL Server Performance for Everyone. Feb 24-25 from 13:30-17:00 CET
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.