I got lots of emails where people wanted to know more about such parameters. Let us discuss 5 Parameters from Config File which can help MySQL Performance.
MySQL Performance – Slow Query and innodb_buffer_pool_size
I have helped my clients with MySQL Performance when I know the solution. Let us discuss Slow Query and innodb_buffer_pool_size.
SQL SERVER – Parameter Sniffing and Bad Plan
Another day and another interesting question by a client Do we still get a bad plan after disabling Parameter Sniffing? Yes!
SQL SERVER – Parallelism in Express Edition
Recently a client reached out to me with a very interesting question, why is he not able to see the parallelism in Express Edition. Let us discuss today.
SQL SERVER – Dirty Pages vs Clean Pages in Memory
I was asked what is the difference between Dirty Pages and Clean Pages in SQL Server Buffer Memory and which one is better? Let us quickly discuss.
Tuning Query Cost 100% – SQL in Sixty Seconds #181
After the blog posts, lots of people asked me to build a video so here is the video discussing the topic of Tuning Query Cost 100%.
SQL SERVER – Correcting Space Allocation with DBCC UPDATEUSAGE
I was recently called an interesting scenario by my client. Let us learn today Correcting Space Allocation with DBCC UPDATEUSAGE.