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 …
Read More »WARNING: AQ_TM_PROCESSES is set to 0
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. …
Read More »How To Find Backup Paths in SQL Server
Most companies have a backup strategy, maintenance procedures. In my article “SQL Server Maintenance“, you can find details about maintenance on sql server. Therefore, …
Read More »CEILING Function in SQL Server(TSQL)
The CEILING function returns the smallest integer value greater than a number. If the number is already an integer, it returns the same number …
Read More »Rman restore process hangs with “Starting implicit crosscheck backup” error
If the RMAN restore hangs with the “starting implicit crosscheck backup” error and has not been completed for a long time, you may have …
Read More »Checksum and TornPage Concepts in SQL Server
Checksum and TornPage Concepts are Page Verify Options. Page Verify is a SQL Server Database Property. Both are methods used to discover and report …
Read More »ABS Function in SQL Server(TSQL)
The ABS function returns the positive value of a negative number. The return data type is the data type of the input parameter. The ABS …
Read More »kjzdattdlm: Can not attach to DLM(instance crash)
Because the cluster_interconnects parameter is set incorrectly in the database instances on Exadata, one or more of the instances can be closed with the …
Read More »Rebuild System Databases in SQL Server
Because of the problems that occur in the system databases, it is sometimes necessary to rebuild. Rebuild operation resets system databases and allows the …
Read More »JSON text is not properly formatted
If you are processing JSON data and the JSON data is not a valid JSON below error will be occurred. Msg 13609, Level 16, State …
Read More »