Problem: You have lots of dynamic SQL updates, with different values each time.

Solution: Bind, don't concatenate, to optimize performance and simplify dynamic string construction.

Read what Ana Choto from American University wrote to us recently about using Toad for Oracle.

A step by step guide to building a TOAD® Reports Manager report that caters for instances where there’s “No Data Found

How to quickly search and open database objects in Toad Extension for Eclipse. Press Command+Shift+D key combination to open the Open Database Object form. Type part of database object name and use arrow key to highlight it among matching items. Then press Enter to open the object.

The new Quest SQL Optimizer for SQL Server 8.0 has two major enhancements: the improved SQL rewrite engine and the new Plan Control SQL tuning module. Today, I want to discuss some new SQL transformation rules in SQL Optimizer 8.0.

 

How to assess the SQL Server internal SQL optimizer performance?

You may be aware that every SQL statement has to be optimized by the database's internal SQL optimizer before it can be processed. Simply speaking, the database's internal SQL optimizer is designed to find the best way to process your SQL statements. There are two major factors to assess a database's internal SQL optimizer. The first is the accuracy of cost estimation and the second is the size of the plan space.

...

Or are they just sociable? Social Media has taken the world by storm, primarily through Facebook, Twitter, Yelp, Foursquare, LinkedIn, etc. And now everyone expects to have access to a network of "friends" wherever they are, through whichever device they are using. This raises an interesting question for those us in the technology world and vendors providing tools in which technologists "live": Does social media/networking...

Here we go again! After having written and blogged about this topic a fair bit in the past, having too many managers is a problem I still continue to see all too often. A good example is a site I worked with recently; it had 20+ managers just to run the workflow background processes.

Putting aside the need to address the excessive workflow background processes (which is another problem in its own right) there are major...

We software developers are a very privileged bunch. We don’t have to work in dangerous environments, and our jobs aren’t physically taxing (though carpal tunnel syndrome is always a threat). We are paid to think about things, and then to write down our thoughts in the form of code. This code is then used and maintained by others, sometimes for decades.

Given this situation, I believe we all have a responsibility to write code that can be easily understood and maintained (and, c’mon, let’s admit our secret desires, admired) by the developers who follow in our footsteps. Look at this way: if you have a child, she might grow up to be a programmer. She might even put in time at one of your previous employers. She might actually end up having to maintain code that you wrote.

The choice is yours: avoid mortifying embarrassment either by never putting your name in your code, or by writing code that you would be proud to show to, share with, and inflict on your own flesh and blood.

Everyone celebrates back to school so we are going to celebrate the end of school for a change.  It just sounds better.  With the fiscal year end upon us and the students clambering for summer the IT department is hunkering down.  End of school is when IT gets busy so let Quest Software help you prepare for the time ahead with a great program.  Toad Plus for Higher Education...

原文：“EXECUTING SQL IN TUNING LAB – PART 10 – PERFORMANCE IMPROVEMENT EXPECTATIONS”  原文投稿日期：2009年8月21日

原文：“EXECUTING SQL IN TUNING LAB – PART 9 – WHY RUN TIMES VARY”  原文投稿日期：2009年8月7日

原文：“EXECUTING SQL IN TUNING LAB – PART 8 – CRITERIA FOR BEST SQL”  原文投稿日期：2009年7月24日

原文：“EXECUTING SQL IN TUNING LAB – PART 7 – TESTING SQL WITH VARIABLES”  原文投稿日期：2009年7月10日

原文：“EXECUTING SQL IN TUNING LAB – PART 6 – TESTING IN A DEVELOPMENT ENVIRONMENT”  原文投稿日期：2009年6月26日

One of the major strengths of Benchmark Factory is the ability to Capture and Replay the activity related to a session. This is important because it doesn’t force the user rely on tracefiles or logs to obtain ‘real world’ production data for replay in a test environment. This is important for the following reasons:

Tracefiles may contain multiple user session details It is often difficult to identify which...

原文：“EXECUTING SQL IN TUNING LAB – PART 5 – SELECTING ALTERNATIVES TO TEST”   原文投稿日期：2009年6月12日

原文：“EXECUTING SQL IN TUNING LAB – PART 4 – EQUAL COMPARISON FOR RUN TIMES: ELIMINATING THE EFFECT OF NETWORK TRAFFIC”  原文投稿日期：2009年5月29日

原文：“EXECUTING SQL IN TUNING LAB – PART 3 – EQUAL COMPARISON FOR RUN TIMES: MINIMIZING THE EFFECT OF OTHER ACTIVITIES ON THE CPU”  原文设稿日期：2009年5月15日

原文：“EXECUTING SQL IN TUNING LAB – PART 2 – EQUAL COMPARISON FOR RUN TIMES: MINIMIZING THE EFFECT OF CACHING” 原文投稿日期：2009年5月1日
作者：虹天软件(珠海)有限公司 杜伟业(Richard To）

原文：“EXECUTING SQL IN TUNING LAB – PART 1 – CRITERIA FOR TERMINATING SQL ”    原文投稿日期：2009年4月17日
作者：虹天软件(珠海)有限公司 杜伟业(Richard To）