Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 »CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file
ERROR MESAGGE: CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting …
Read More »Database cannot be upgraded because it is read-only or has read-only files
ERROR MESAGGE: Database cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery. (Microsoft …
Read More »Login failed for user. This user is not associated with a trusted SQL Server connection.
ERROR MESAGGE: Login failed for user . This user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) EXPLANATION: …
Read More »