MSSQL

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 …

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

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 …

  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 …

  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 …

  How do you find out if a specific record in a particular table is in the Buffer pool / data cache or in the …