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

  Files that are created accidentally or deliberately in the file system in a database that uses ASM often cause problems. In particular, a file …

DBCC CHECKFILEGROUP checks the consistency of all tables and indexed views on the filegroup. To examine in more detail what Filegroup is, you can read …

  In some projects or scenarios, we need to move some databases between different SQL Server editions. For example, in some organizations, SQL Server Evaluation …

  With a single command: [crayon-6767e44a927af887445571/] If you run this way, you will be opening this Trace Flag to Global, and even if your SQL …

  ERROR: Message Executed as user: DOMAIN\svc_SQLService. The transaction log for database ‘dbname’ is full due to ‘LOG_BACKUP’. [SQLSTATE 42000] (Error 9002)  BACKUP DATABASE is …

  I was doing some security work to make a SQL Server production environment safer and ready for inspections. I had more than 900 SQL …

  We can change the size of the ACFS file system online without requiring any umount or disable volume. We use the acfsutil tool for …

The DBCC CHECKDB command is used to detect and repair logical and physical errors that occur in the database. When you run the DBCC CHECKDB …

  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 …