This post contains spoilers for new version of LiteSpeed! Read under your entire responsibility. Don't tell me I did not warn you! We know that with LiteSpeed for SQL Server 8.5 we can backup to Azure...
Hi, Code Analysis has been in Toad for a while now. If you are using a slightly older version of Toad, it might be called Code Review, found under the same menu path. Code Analysis gives you or your...
Introduction Materialized views have been used for several years and they are being improved by Oracle with every database version or release. Up to Oracle Database 12cR1 Oracle Materialized Views sup...
Have you have found running a workflow in Oracle Data Miner slow or running the scripts in the database slow ? No. Good, because I haven't found it slow. But (there is always a but) it really depends...
If your IT department or development team is like a lot of those I talk with (and have worked in), you have a lot of scripts that do all sorts of things. They are important to you, and that’s why yo...
Introduction Data changes frequently in OLTP environments and Oracle has to be aware of those changes or at least to try detect these changes in order to adjust the optimizer and execute sentences in ...
The Query Builder enables you to create a query without writing or editing SQL statements. Even if you are familiar with SQL, the graphical interface makes it easier to create relationships and visual...
Use the Database Diagram to view a high-level, visual representation of an object and those objects which may be related to it. This helps you easily identify relationships between tables via foreign ...
Fear and confusion: two emotions you probably don’t like associated with your job. I see it often in my line of work, and have seen it for many years since I started working with mainframe files and ...
Introduction In SQL Optimizer version 9, a very helpful feature was introduced:“Test Run Different Bin d Values”. This new feature allows user to define more than one binds set that can be used in tes...
The Query Builder enables you to create a query without writing or editing SQL statements. Even if you are familiar with SQL, the graphical interface makes it easier to create relationships and visual...
The Dimensional Viewer allows you to build a custom, multi-dimensional view of data. Drag columns from the Field List to the work area to create a view. You can apply aggregate fields and use rollup c...
