The F6 Shortcut moves focus between SSMS panes. I use it when switching between the query editor and results.
SSMS or VS Code for SQL Server Work
Choose SSMS or VS Code for SQL Server work by task: administration, plans, scripts, MSSQL extension features, and team workflow.
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Group Photo
MVP Open day 2008 is one of the best event happened so far. I have previously written about this event in detail on this blog.
Baselines: Knowing What Normal Looks Like
Build a SQL Server baseline with timestamped workload, wait, and IO samples so you can compare a slowdown with a similar period of normal work.
SQL SERVER – Check Database Integrity for All Databases of Server – DBCC CHECKDB
A quick script to check database integrity for all the databases on a server with DBCC CHECKDB and sp_msforeachdb, and how to read its output.
Why WHERE Runs Before SELECT
Learn logical query processing to understand WHERE, SELECT aliases, grouped filters, and ordering without confusing syntax with execution.
Why One Query Has Two Cached Plans: SET Options and plan_attributes
Investigate two cached plans with plan_attributes, decode differing SET options, and match application settings before diagnosing skew.