SQL Server 2016 lets you set MAXDOP on DBCC checks like CHECKDB. Here is how this DBCC Command enhancement works and how to use it.
Telling Which Platform You Run On With SERVERPROPERTY EngineEdition
Read EngineEdition with edition and version properties, select platform-aware diagnostics, and avoid treating an engine family as a license.
Columnstore Segment Elimination: Loading Data So Scans Skip Work
See how segment elimination skips columnstore work by checking segment metadata, measuring scans, and loading rows in a useful order.
In-Place Upgrade or Side by Side: Choosing Properly
Compare an in-place upgrade with a side-by-side SQL Server migration, including downtime, testing, dependencies, and recovery after cutover.
SQL SERVER – Unable to Bring Resource Online – Error – Could Not Find Any IP Address that this SQL Server Instance Depends Upon
A clustered SQL Server could not find any IP address it depends upon, so it would not start. Here is how to fix it and bring the resource online.
Network Packet Size: When a Bigger Packet Helps Large Results
Test network packet size on a specific SQL Server connection, verify the negotiated value, and compare large-result performance carefully.
How to Find Size of All the Indexes on the Database – Interview Question of the Week #097
Need to know how much space your indexes use? Here is a script I share with clients that lists all the indexes in a database along with their size.