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 …

Detect Orphaned Windows Logins(sp_validatelogins) With this system SP, you can identify Windows Logins that have been deleted from Active Directory on a SQL Server Instance. …

  With the DB link, you can get an ORA-01591 error if you join the tables in the queried database with the tables in a …

  For more information about Filegroup, please read the article “How to Create a Database on SQL Server“. Especially in large and partitioned databases, we …

  When you try to get a backup with Rman, if you get errors like ORA-27086, ORA-01580, the first place you should check is nfs …

We perform FileGroup Backup and Restore operations in databases that are usually large and have more than one filegroup, while some of the filegroups are …

  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 …