Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

  In busy databases you may encounter this wait event. The general reason is the low redo log I/O performance or the slow interconnect connection. …

  DBCC UPDATEUSAGE Detects and corrects errors in Page and row numbers. Prior to SQL Server 2005, the number of rows of some of the …

  The default is case sensitive, so the following query returns no lowercase. In this case, the returned result will contain missing data. [crayon-673f36f6a401e589588137/] If …

DBCC CHECKCATALOG performs various consistency tests between system metadata tables. If you run DBCC CHECKDB, you do not need to run DBCC CHECKCATALOG. For details …

  ERROR: The database dbname is not accessible. (Object Explorer) EXPLANATION: Actually, I wouldn’t write an article for this error, but when I saw that …

  Oracle ASM Cluster File System (ACFS) is used to create a cluster file system via ASM. The created file system will use the space …

  When we create our tables, we set some columns to be null, so that some columns are never null. If the columns that we …

  The answer to this question depends on the size of the database that you are running this command, the parameters you will use with …

  A colleague today said they received an error like this: Msg 2627, Level 14, State 1, Procedure SP_name, Line 33 Violation of PRIMARY KEY constraint …

  There are many tables and views in Oracle database that we can get information about with locked objects. You can access a lot of …