Question: What is the Replacement of DBCC DBREINDEX?
Answer: The answer to this question is very simple.
Here is the syntax:
SQL SERVER – Stop Using DBCC DBREINDEX and Use ALTER INDEX
It has been over a decade since the comment DBCC DBREINDEX has been deprecated, however, once in a while I still encounter them while working with clients.
SQL SERVER – Removing Extra TempDB Files
The other day I ended up a very interesting situation while working with Comprehensive Database Performance Health Check, with TempDB files.
SQL SERVER – How to Shrink tempDB Database?
In the email yesterday from the client who earlier hired me for performance tuning had a small question about how to shrink tempdb database.
SQL SERVER – DBCC CHECKDB WITH PHYSICAL_ONLY Failing and DBCC CHECKDB Succeeding – Bug
One of my previous clients recently reached out with a strange bug where DBCC CHECKDB WITH PHYSICAL_ONLY failed and DBCC CHECKDB Succeeded.
SQL SERVER – DBCC CLONEDATABASE Error – Msg 2601: Cannot Insert Duplicate Key Row in Object ‘sys.sysowners’ With Unique Index ‘nc1’.
A few days ago, I wrote a blog about an error while creating a clone of a database using DBCC CLONEDATABASE command. Here is the link to read that blog.
SQL SERVER – DBCC CLONEDATABASE Error: Cannot Insert Duplicate Key Row In Object ‘sys.sysschobjs’ With Unique Index ‘clst’.
Learn how to fix: Cannot insert a duplicate key row in object ‘sys.sysschobjs’ with unique index ‘clst’ while using DBCC CLONEDATABASE.