MSSQL

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-684707c20c6a1100453132/] 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 …

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 …