Question : I have SQL Server 2008 R2 database in Suspect mode. I tried to fix it running this query: […]
Tag: dbcc
What are the downsides of running DBCC FREESYSTEMCACHE (‘TokenAndPermUserStore’) hourly?
Question : I have been seeing some concerning behavior in the SQL Server memory caches on one of our production […]
DBCC shrink file history
Question : I ran shrink file(.mdf) through GUI by selecting Task -> Shrink -> Files and selected second option i.e […]
Using the sysadmin role with EXECUTE AS
Question : It is my understanding that I can use the EXECUTE AS OWNER clause as part of a procedure […]
DBCC PAGE read page from buffer pool or directly from the file system?
Question : We know that SQL Server always read pages from disk to memory for all its operations. So it’s […]
Page Number in SQL Server database is not starting from zero
Question : I have a question on SQL Server page, I have created a new database with only one new […]
DBCC TRACEON with the global flag
Question : In the question Need Help Troubleshooting Sql Server 2005 Deadlock Scenario there was a suggestion of using DBCC […]
Unexplainable DBCC CHECKDB Command Output
Question : Microsoft SQL Server 2017 (RTM-CU14-GDR) (KB4494352) – 14.0.3103.1 (X64) Mar 22 2019 22:33:11 Copyright (C) 2017 Microsoft Corporation […]
MS SQL Server: DBCC ShrinkDatabase – Does it really not shrink the database below the minimum size?
Question : Per Microsoft’s documentation on DBCC ShrinkDatabase command, it shouldn’t shrink the database below it’s “minimum size”. But when […]
Can you embed DBCC Shrinkfile into a IF statement?
Question : I have an issue where my maintenance job Transaction logs do not always shrink when DBCC SHRINKFILE is […]