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.
SQL SERVER – FIX: Incorrect Syntax Near the Keyword ‘PROCEDURE’
A reader’s ALTER PROCEDURE worked alone but failed inside an IF EXISTS block with incorrect syntax near the keyword ‘PROCEDURE’. Here is why and the fix.