What does the query optimizer hint ROBUST PLAN do? I explain query hints in simple words and ask you for a practical example of ROBUST PLAN in action.
SQL SERVER – Performance Counters from System Views – By Kevin Mckenna
SQL and .NET expert Kevin Mckenna, whom I met on Twitter, shows how to read SQL Server performance counters from system views.
Ordered Columnstore Indexes in SQL Server 2022
Build an ordered columnstore index in SQL Server 2022, inspect segment bounds, and compare range-query reads on your own data.
Adaptive Joins: When the Plan Picks Its Join at Run Time
Understand adaptive joins in SQL Server, read their runtime threshold, inspect the actual choice, and test a query hint safely.
SQL SERVER – Introduction to SQL Server 2008 Profiler – Summary
An introduction to SQL Server 2008 Profiler: how to create, watch, store and replay a trace to see what runs under the SQL Server engine’s hood.
SQL SERVER – Automated Index Defragmentation Script
Fragmentation from inserts, updates and deletes slows tables down. For index defragmentation I use the automated script by my friend Michelle Ufford (SQLFool).
How Many CPUs SQL Server Really Uses
CPUs SQL Server really uses depend on edition, guest topology, affinity, and online schedulers; learn to see the instance’s usable capacity.