(Bobby Durrett) This is nothing new, but I wanted to throw out a quick post to document it. If you have a sequence.nextval in the insert part of a merge statement the merge calls nextval for all the updated rows as well.
Community
Monitoring Table Change in Oracle
(David Fitzjarrell) Database replication is no longer restricted to Oracle-to-Oracle configurations; Oracle-to-cloud and Oracle-to-BigQuery are just two of the various options that can now be selected for replication configurations.
SQL SERVER – SET NOCOUNT – Impact on Stored Procedure Performance
(Pinal Dave) Sometimes it is critical to get back to basics when working on solving a complex problem at Comprehensive Database Performance Health Check. Recently, I solved a huge performance problem for one of my clients by just adding the SET NOCOUNT inside the stored procedure.
Hide/Show Form Fields Using Angular Forms
(Vidyadharran G) In this article, I will explain about hiding and showing form fields using Angular forms. Forms are used in web applications that enable the users to enter data and process the data from it.
A beginner’s guide to Java agents
(Rafael Winterhalter) While Java beginners quickly learn typing public static void main to run their applications, even seasoned developers often do not know about the JVM’s support of two additional entry points to a Java process: the premain and the agentmain methods.
Getting ColdFusion Date Objects From UTC Milliseconds In Lucee CFML 5.3.3.62
(Ben Nadel) The fun thing about maintaining a legacy code base is that you’re constantly turning over stones to find new and exciting areas of code-rot and technical debt. Just yesterday, I discovered that one of my ColdFusion servers was deadlocked on some Date/Time code that was not thread-safe.
Time in Performance Schema
(Valerii Kravchuk) I’ve seen questions like this: “Is there a way to know when (date and time) the last statement captured in … was actually ran?”
Alternative for Oracle Multimedia: APEX Media Extension
(Dimitri Gielis) If you are reading this blog post you are probably searching for an alternative for the deprecated multimedia (or intermedia) feature of the Oracle Database… and you are in the right post as APEX Media Extension is that replacement!
SQL Server User Defined Function Example
(Rick Dobson) SQL Server offers three types of user defined functions (udf) and in this tip we will cover examples for each of the three major types of user-defined function types: scalar-valued, table-valued and multi-statement table-valued.
A technique for building high-performance databases with EF Core
(Jon P Smith) As the writer of the book “Entity Framework Core in Action” I get asked to build, or fix, applications using Entity Framework Core (EF Core) to be “fast”. Typically, “fast” means the database queries (reads) should return quickly, which in turn improves the scalability of the database.