Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
We use the incremental backup of the primary database to fix the gap that occurs in the standby databases. If the managed recovery is turned …
Read More »
How To Use kfod and kfed on Exadata
kfed and kfod are under $ORACLE_HOME/bin. With these tools, we can learn about asm disks and edit the information in the disk headers. When using …
Read More »
What is CLR and How to import dll in sql server
CLR is a feature introduced with SQL Server 2005. Using the CLR (Common Language Runtime), you can perform a number of complex processes that you …
Read More »
How To Create Unique Index On Partitioned Tables in SQL Server
In the article named “Can Not Switch The Partition On SQL Server“, we mentioned that all indexes in the partitioned table should be aligned according …
Read More »
How To Find Serial Numbers of Exadata Servers and Components
The serial numbers and part codes of the compute nodes and cellnodes and components in these nodes in the Exadata are required to supply the …
Read More »
Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit
Sometimes the transaction log file may grow more than normal for some reasons. For example when the transaction logs are not backed up. In the …
Read More »
READ Object Privilege in Oracle 12c
The READ object privilege introduced with the 12c (12.1.0.2) version. It allows us to read a table without locking. It is used to create read-only …
Read More »
Create Index On the GROUP BY Column
Before you start reading this article, I suggest you read the article “Index Concept and Performance Effect on SQL Server” for more detailed information about …
Read More »
Oracle Direct NFS (dNFS)
Oracle Direct NFS (dNFS) is an optimized NFS client that provides faster and more scalable access to NFS storage in NAS storage devices. Direct NFS …
Read More »
Create Index on the Order By Column(ASC,DESC)
Before you start reading this article, I suggest you read the article “Index Concept and Performance Effect on SQL Server” for more detailed information about …
Read More »