Toad World Blog
Richard To
Richard specializes in using AI technique to solve database performance problems.Richard To
If you want to find the minimum salary among all employees, you may issue a SQL ...
Keep reading >
Posted on Jun 10, 2015 11:27:02 PM by
Richard To
I have heard a lot of people ask "Why my SQL performance is vary depending on where ...
Keep reading >
Posted on Apr 22, 2015 10:51:56 PM by
Richard To
Here is part of a case study that I would like to share with our users:
Keep reading >
Posted on Feb 2, 2015 3:01:00 AM by
Richard To
There are mainly three problems that database SQL optimizer cannot find the best way ...
Keep reading >
Posted on Oct 22, 2014 1:58:49 AM by
Richard To
In SQL Optimizer for SQL Server we have built a very useful test run wizard (see my ...
Keep reading >
Posted on Sep 15, 2014 2:00:00 AM by
Richard To
In SQL Optimizer for SQL Server, we have built a very sophisticated test run ...
Keep reading >
Posted on Jun 5, 2014 10:18:00 PM by
Richard To
A junior developer came to me recently and asked me a SQL transformation question. ...
Keep reading >
Posted on Apr 10, 2014 8:39:00 PM by
Richard To
This blog is the finale in this series about common misconceptions surrounding SQL ...
Keep reading >
Posted on Mar 4, 2014 8:40:14 PM by
Richard To
Using SQL Rewrite mode in Optimize SQL consists of two steps. In the first step, SQL ...
Keep reading >
Posted on Jan 11, 2013 12:13:00 PM by
Richard To