DBCC UPDATEUSAGE is a command available in SQL Server that is used to update the page and row count metadata for database objects.
SQL SERVER – Manage Database Size with DBCC SHRINKDATABASE and WAIT_AT_LOW_PRIORITY
In this blog post, we will explore the DBCC SHRINKDATABASE command and its options, focusing on the WAIT_AT_LOW_PRIORITY feature.
Checking Constraints After a Bulk Load With DBCC CHECKCONSTRAINTS
Run DBCC CHECKCONSTRAINTS after a controlled bulk-load bypass, inspect violations, and restore enabled trusted CHECK and foreign-key rules.
SQL SERVER – Empty Database Authentication Cache with DBCC FLUSHAUTHCACHE
A very interesting DBCC command I recently came across and that is DBCC FLUSHAUTHCACHE. DBCC function applies to Azure SQL Database.
Checking Last Good DBCC CHECKDB Time With LastGoodCheckDbTime
Inspect LastGoodCheckDbTime for each database, flag stale or unavailable checks, and compare metadata with retained integrity-job evidence.
SQL SERVER – When to Use DBCC CLEANTABLE?
Recently a client of mine asked me – When to Use DBCC CLEANTABLE? A question to be discussed in Comprehensive Database Performance Health Check.
SQL SERVER – Correcting Space Allocation with DBCC UPDATEUSAGE
I was recently called an interesting scenario by my client. Let us learn today Correcting Space Allocation with DBCC UPDATEUSAGE.