Beyond DBCC IND and EXTENTINFO, the DMV dm_db_database_page_allocations shows table space allocation details. My friend Balmukund pointed me to it.
SQL SERVER – Using Bitwise And (&) Instead of a Junction Table – Notes from the Field #053
Stuart Ainsworth shows a cool trick: using Bitwise And (&) instead of a junction table to get more performance with fewer code changes.
Azure SQL Database Wait Stats: Reading sys.dm_db_wait_stats
Read Azure SQL Database wait stats with sys.dm_db_wait_stats, identify log-rate governance, and compare resource percentages before scaling.
SQL SERVER – Unable to Restore From Backup After Detach Operation
A young guy came to me and said – “I found a bug in SQL Server Restore”. How to fix Unable to Restore From Backup After Detach Operation.
SQL SERVER – PowerShell way of Restarting SQL Server Service
Restarting SQL Server service with PowerShell is one line, and it is wrong on a named instance. The right name, -Force, and when it is really up.
Linked Server Logins: Stop Mapping Everyone to sa
Audit linked server logins for blanket remote sysadmin mappings, test with a low-privilege identity, and replace broad access safely.
SQL SERVER – What are my Trace Flags Enabled on SQL Server?
A DBA friend wanted to see the trace flags enabled on his production servers. Here is how to find them easily, and a word of caution about using them.