Large database size Distribution MS SQL Server
- 14 November 2022
- Database Performance ManagementMachine learning
Sometimes you have to face the situation when in Microsoft SQL Server with the configured replication, the database distribution starts to grow. There…
Oracle NULLIF function
Oracle/PLSQL NULLIF function compares expr1 and expr2. If expr1 and expr2 are equal, the function NULLIF returns NULL. Otherwise, it returns expr1….
Oracle SQLCODE function
- 12 November 2022
- Database Performance ManagementMachine learning
The SQLCODE function returns the error number associated with an exceptional situation. This function can only be used in the exception handling secti…
PSQL POSTGRESQL POWERUSER PRACTICE: GEXEC
- 9 November 2022
- Database Performance ManagementMachine learning
Automating routine tasks is becoming more and more important for PostgreSQL power users, and gexec can help. This article will demonstrate how to use …
Oracle SQLERRM function
The SQLERRM function returns an error message related to an exceptional situation. This function can only be used in the exception handling section of…
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!