SQRT function returns the square root of a float value and the return data type is float. SQUARE function returns the square of a …
Read More »RMAN-08137 archived log not deleted, needed for standby or upstream capture process
When the “AVDF transaction log audit trail” is created and deleted, the archive logs cannot be deleted normally, depending on bug 23217905. The problem …
Read More »What is Filtered Index in SQL Server
The Filtered Index is a filtered nonclustered index. For example, you have 100,000 records in a table. And some of your queries are only …
Read More »SIGN Function in SQL Server(TSQL)
The SIGN function determines whether a number is negative, 0, or positive. If the number is negative, it returns -1, If the number is …
Read More »How To Delete Trace Files, listener log etc with ADRCI
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, …
Read More »Update Specific Row in EDIT TOP 200 Rows and Change the Query for EDIT TOP 200 Rows in SQL Server Management Studio
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 …
Read More »FLOOR Function in SQL Server(TSQL)
The FLOOR function returns the largest integer value smaller than a number. If the number is already an integer, it returns the same number …
Read More »There is a slowness problem when you query dba_free_space or tablespace in 12c
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 …
Read More »How To Change Default Value for Select Top 1000 Rows and Edit Top 200 Rows
The “Select Top 1000 Rows” and “Edit Top 200 Rows” options in SSMS are known to many people interested in SQL Server. I never …
Read More »EXP Function in SQL Server(TSQL)
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 »