Build an included column index to cover SQL Server queries, compare plans and reads, and distinguish key limits from leaf-level payload.
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.
SQL SERVER – What Does WHERE 1=1 Mean in the Code?
Why do people write WHERE 1=1 in code? It makes building dynamic WHERE conditions easy, since each optional filter can just add an AND clause.
SQL SERVER – What is Windows Internal Database Edition?
Ever seen Windows Internal Database in an ERRORLOG? I explain what this special edition of SQL Server is and where you are likely to find it.
SQL SERVER – Fix: SQL Server CPU Schedulers Offline
A reader’s 80 core server was not using all cores in SQL Server. Here is how to spot CPU schedulers offline and the usual reasons behind them.
SQL SERVER – Basic architecture of Transaction Logs
The SQL Server transaction log works like a string of log records, each with an LSN. My simple notes on the basic architecture of transaction logs.