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

  ERROR: Description: The package is encrypted with a password. The password was not specified, or is not correct. End Error Could not load package …

  ERROR: Property ErrorLogFile is not available for JobServer ‘server_name’. This property may not exist for this object. EXPLANATION: In SQL Server Management Studio, you …

  In some cases, automatic maintenance jobs are closed in databases. In this case, the schema statistics are not collected and cause serious performance problems. …

  Tail Log Backup takes the backup of log records that have not yet been backed up. We can use this backup to return to …

  If you receive errors in the form of ORA-20005 and ORA-06512 during the collection of the table statistics, you must unlock the relevant table …

DBCC CHECKTABLE is used to test the consistency of a table or indexed view. The DBCC CHECKTABLE command performs the same operations as the DBCC …

  In the Replication Monitor, you can see a message for a long time in the tab “Distributor to Subscriber History”. When you see this …

  In some cases, depending on the corruption of the binary files, strange behavior can be observed in the program. It’s possible to encounter strange …

When the database is created or manually increased in size or when it grows with auto growth, it allocates a space over the disk. With …

  In the previous post we discussed how it is possible to extract your Integer values from IBM’s new Db2 table as of Db2 for …