Sequence is a table-independent structure similar to the identity logic in SQL Server. You can use the sequence in more than one table. You …
Read More »ORA-01567 Error During Redo Log Group Drop Operation
If we are trying to drop the redo log group created for a thread that is active and if the drop operation of redo …
Read More »The certificate ‘xxx’ cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate)
You may need to delete the certificate that you created with TDE(Transparent Data Encryption) during the database encryption process. And during this deletion process, …
Read More »How To Concatenate Query Results in SQL Server(TSQL)
The other day I had to concatenate a query result. In this article, I’m going to tell you how to do this through an example. …
Read More »How To Delete the Last Character of a String in TSQL(DATALENGTH and LEFT Functions)
When developing code in TSQL, we may need to delete the last character of a string in some cases. The other day, I used the …
Read More »INTERSECT Operator in SQL Server(TSQL)
We can use the SQL INTERSECT Operator between two SQL Statement. This operator returns the intersection of the first SQL Statement and the second SQL …
Read More »Querying information about Exadata cellnode
We can query all the information about the cellnodes on Exadata from any database. It is possible to query information from v$cell_config. With this view, …
Read More »How To Monitor Application Error with Extended Events
When there is an error in the database, the first place to look at is SQL Server Error Log. Sometimes there is no problem …
Read More »EXCEPT Operator in SQL Server(TSQL)
We can use the SQL EXCEPT Operator between two SQL Statement. It allows us to return records that exist in the first SQL Statement, but …
Read More »SQL 2017 In-Memory Table
Hello there, In-Memory concept, which was first introduced into our lives with SQL 2014, was made more useful and compatible with SQL 2017. In this …
Read More »