In the world of paradigm shifts, many organizations are looking at the prospect of a technology migration, where capabilities are moved to a new set of technologies, supporting and enabling the business for the future. On other hand, a technology or platform may reach the end of its life for other business reasons, like ease of use, increased cost, etc.
2018-08-07
3,088 reads
David Fitzjarrell takes a look at why the mutating table error is thrown, why it's not going to create data problems, and how to possibly fix it.
2016-07-01
3,541 reads
Sometimes it's good to re-think how to write a query; set operations can provide performance benefits over 'straight SQL'. In this article, David Fitzjarrell takes a look at one such example in action.
2016-05-25
3,710 reads
Oracle offers a number of security-related settings, but one could definitely create more harm than good. David Fitzjarrell looks at which parameter that is, and why.
2016-03-24
5,227 reads
Defining unique records in an Oracle table is necessary for employee data, and manufacturing part numbers and user names, to name a couple of examples. David Fitzjarrell looks at the various ways uniqueness can be defined, and which method may not be acceptable to third-party applications.
2016-02-26
386 reads
Oracle 12.1.0.2 can throw an ORA-01438 when importing an interval partitioned table. In this post, David Fitzjarrell suggests a work-around until Oracle patches the bug.
2015-12-25
3,295 reads
David Fitzjarrell looks at how and why to use a feature called Automatic Column Group Detection to recognize column dependencies and create extended statistics on recognized groups in Oracle 12.1.0.2.
2015-11-11
3,177 reads
Oracle offers a results cache in the database (from 11.2 onwards) and in PL/SQL (again, from 11.2 onwards) which can greatly reduce execution time of repeated statements when insert/update/delete activity is not heavy. The mechanism in PL/SQL, however, may not work as expected with global temporary tables. Using a slightly modified example, Jonathan Lewis looks at what you might see when using this option.
2015-10-22
4,120 reads
Automatic UNDO Management isn't voodoo or black magic, although it can seem that way when it isn't clearly understood. How does Oracle decide how many UNDO segments to create at startup, and what is the underlying goal of the process? David Fitzjarrell investigates.
2015-10-06
3,322 reads
Designing a system with primary keys in mind is not an easy task, and the solutions may not be the simplest. However the effort is well worth the time and trouble when you realize that it's the best way to prevent duplicate data - but how do you choose a primary key? David Fitzjarrell looks at several examples.
2015-08-25
4,312 reads
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
By Steve Jones
A few years ago SQL Prompt added a command palette to let you search...
The Identity property creates an incremental value for the specified column automatically, which is...
We have about 20 SQL Servers. We use Net backup or Native backup for...
I have one SQL Database server which is old version and planning to migrate...
Comments posted to this topic are about the item Restore With Standby; A Review...
Ask SSC