I was recently called an interesting scenario by my client. Let us learn today Correcting Space Allocation with DBCC UPDATEUSAGE.
Yes, you read it right it is not possible to use DBCC DBREINDEX with MAXDOP hint as far as I know. If there is any method to use it.
Question: How to Change Database File Size?
Answer: By Shrinking the files. Now, many have a negative opinion about Shrinkfile.
In yesterday’s session, a DBA asked an interesting question that if it is possible to have two identity columns for a single table. Yes and No.