Compare EXCEPT operator vs. NOT IN using NULL and duplicate examples, add NOT EXISTS, and inspect actual SQL Server anti-join plans.
The Milestone – Notes from the Field #100
The 100th episode of Notes from the Field is a true milestone. A thank you to the experts who shared real-world lessons with all of us.
Plan Guides: Fixing a Query You Cannot Change
Apply plan guides to a parameterized query you cannot edit, validate the guide, confirm plan matching, and compare Query Store hints.
SQL SERVER – To Find Events Mapped to Channels in Extended Events
How exhaustive are Extended Events compared to Profiler? A DBA asked me, so here is how to find events mapped to channels in Extended Events.
SQL SERVER – Error Fix: Msg 300, VIEW SERVER STATE
Fix SQL Server Msg 300 when a user lacks VIEW SERVER STATE permission, and learn how to grant it safely without giving away too much access.
SQL SERVER – Linked server creation error: OLE DB provider “SQLNCLI11” for linked server returned message “Invalid authorization specification”
Creating a linked server between two local instances failed with OLE DB provider SQLNCLI11 returned Invalid authorization specification. Here is the fix.
SQL SERVER – Three Simple Guidelines for System Maintenance – Notes from the Field #098
Notes from the Field #098: three simple guidelines for system maintenance. Automate what you can, document the rest, and always validate.