Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

With ADRCI, it is possible to delete files such as “log, trace, incident, cdump” created before a certain day. Instead of manually deleting individual files, …

Most database experts, or TSQL developer knows EDIT TOP 200 Rows option. When you click EDIT TOP 200 Rows by right-clicking on the table, unlike …

  The FLOOR function returns the largest integer value smaller than a number. If the number is already an integer, it returns the same number …

  There may be a slowdown when you query dba_free_space or tablespaces via Toad on 12C databases. The slowness is due to the fact that …

  The “Select Top 1000 Rows” and “Edit Top 200 Rows” options in SSMS are known to many people interested in SQL Server. I never …

  EXP Functions calculates the exponential value of a parameter that has the float data type. This function’s return data type is float. Below you …

You can see “WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.” warnings at certain intervals in the database alert log file. …

  Most companies have a backup strategy, maintenance procedures. In my article “SQL Server Maintenance“, you can find details about maintenance on sql server. Therefore, …

  The CEILING function returns the smallest integer value greater than a number. If the number is already an integer, it returns the same number …

  If the RMAN restore hangs with the “starting implicit crosscheck backup” error and has not been completed for a long time, you may have …