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

  The default is case sensitive, so the following query returns no lowercase. In this case, the returned result will contain missing data. [crayon-67682f508cbb5257039206/] 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 …

  In the article named “FileGroup Backup and FileGroup Restore Operations On SQL Server(Partial Backup-Restore)“, I explained the issue that we can restore only read-write …

  Interesting title, right? We may want to see the processes that are currently running, especially when there are problems. In these cases you can …