Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
When a database completely crashes, you need to do is to setup from scratch and return from backup. If you have a Rman backup …
Read More »Oracle Exadata Default Passwords
Exadata installation is done with standard user name and password unless you specify otherwise. All standard passwords must be changed. The standard user name …
Read More »Mirror Backup On SQL Server(Multiple Copies of a Backup)
You may want to import a database backup on multiple disks as multiple copies. For example, suppose you have a storage that you use …
Read More »The index “Index_name” (partition ) on table “Table_name” cannot be reorganized because page level locking is disabled
ERROR MESAGGE: “The index “Index_name” (partition ) on table “Table_name” cannot be reorganized because page level locking is disabled” EXPLANATION: If the Index in which …
Read More »An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by the fact that
ERROR MESAGGE: “An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by …
Read More »Length of LOB data (xxxxx) to be replicated exceeds configured maximum 65536. The statement has been terminated.
ERROR MESAGGE: “Length of LOB data (xxxxx) to be replicated exceeds configured maximum 65536. The statement has been terminated.” EXPLANATION: You may experience such …
Read More »Msg 14684, Level 14, State 1, Procedure sp_syscollector_create_collection_set, Line 203
ERROR MESAGGE: “Msg 14684, Level 14, State 1, Procedure sp_syscollector_create_collection_set, Line 203 Caught error#: 2627, Level: 14, State: 1, in Procedure: sp_syscollector_create_collection_set, Line: 137, …
Read More »Random Data Selection(TABLESAMPLE)
Did you know that TABLESAMPLE can be used after FROM to select random data from a table? For example you can use the following: …
Read More »DBA_TAB_MODIFICATIONS table does not return any record
In the DBA_TAB_MODIFICATIONS table, change statistics for all changed tables in the database are stored. The same information can also be accessed from the …
Read More »How To Find SQL Server Database Compatibility Level
In this article I will share the information of finding database compatibility level. If may want to read more about SQL Server Compatilibility Level, …
Read More »