June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
Config File

MySQL Performance – 5 Parameters from Config File

August 10, 2021
Pinal Dave
SQL
MySQL, SQL Memory, SQL Scripts

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. 

Read More
bufferpool

MySQL Performance – Slow Query and innodb_buffer_pool_size

August 9, 2021
Pinal Dave
SQL
MySQL, SQL Memory, SQL Scripts

I have helped my clients with MySQL Performance when I know the solution. Let us discuss Slow Query and innodb_buffer_pool_size. 

Read More
bad plan

SQL SERVER – Parameter Sniffing and Bad Plan

August 5, 2021
Pinal Dave
SQL Performance
Parameter Sniffing, Query Hint, SQL Scripts, SQL Server

Another day and another interesting question by a client Do we still get a bad plan after disabling Parameter Sniffing? Yes!

Read More
Parallelism in Express

SQL SERVER – Parallelism in Express Edition

August 4, 2021
Pinal Dave
SQL Performance
Parallel, SQL CPU, SQL Scripts, SQL Server

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. 

Read More
Clean Pages

SQL SERVER – Dirty Pages vs Clean Pages in Memory

August 3, 2021
Pinal Dave
SQL Performance
SQL Memory, SQL Scripts, SQL Server

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.

Read More
query cost

Tuning Query Cost 100% – SQL in Sixty Seconds #181

July 27, 2021
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Scripts, SQL Server

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%.

Read More
DBCC UPDATEUSAGE

SQL SERVER – Correcting Space Allocation with DBCC UPDATEUSAGE

July 26, 2021
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server DBCC

I was recently called an interesting scenario by my client. Let us learn today Correcting Space Allocation with DBCC UPDATEUSAGE. 

Read More
Previous 1 … 4 5 6 7 8 9 10 … 318 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version