The Query Rewriter Plugin in MySQL is a component that allows you to modify incoming SQL queries before execution. It provides the ability to...
Leveraging Plan Guides in MS SQL Server can prove beneficial for optimizing the performance of a particular query within database objects like...
Using Plan Guides to tune third-party applications SQL in MS SQL Server can be a useful technique when you need to optimize the performance of a...
Performance deployment is a critical aspect of software deployment that is often undervalued. While it's important to ensure that software is...
To properly evaluate the impact of a set of SQL statements during a database environment change, it's crucial to have a thorough understanding of...
The Query Store feature in SQL Server serves as a valuable tool for troubleshooting performance issues by allowing users to quickly identify...
The previous article “How To Use 80/20 Rule To Tune A Database Application I “ demonstrated how the 80/20 Rule can be applied to evaluate the...
In 2002, Microsoft reported that the majority of errors and crashes in their software were caused by a minority of the bugs they detected,...
Here is an example SQL, the query is retrieving employee, department, and grade tables from the remote database @richdb SELECT * FROM...
Here is an example SQL query used to calculate the average salary of employees on the remote database @richdb in each department in the local...
Here is an example SQL that retrieves data from EMPLOYEE and DEPARTMENT table with the employee’s grade code in the GRADE table. SELECT emp_id,...
Here the following is a simple SQL statement with a CASE expression syntax. SELECT * FROM employee WHERE CASE WHEN emp_salary<...
Some business requirements may need to compare the lower case of an indexed column to a given string as a data retrieval criterion. Here is an...
Here the following is an Update SQL with a subquery that updates the EMPLOYEE table if the emp_dept satisfies the records returned from a...
You may suffer from SQL statements with a slow first execution time due to the long data cache process. The following SQL is simple that retrieves...
Here the following is an example SQL shows you that select the maximum emp_address which is not indexed in the EMPLOYEE table with 3 million...
We used to use FORCE INDEX hints to enable an index search for a SQL statement if a specific index is not used. It is due to the database SQL...
For some SQL statements with multiple Max() functions in the select list and nothing in the Where clause, we have different methods to create new...
Separate names with a comma.
