Query cost does not tell you how much data a query returns. Client statistics in SQL Server Management Studio do, and there are three ways to turn them on.
SQL SERVER – Plan Caching and Schema Change – An Interesting Observation
What counts as a schema change for plan caching? More than table structure: adding or dropping an index also qualifies, per Greg Low’s white paper.
SQL SERVER – Forgot the Password of Username SA
Forgot the password of username SA? Resetting it is easy when another sysadmin login or a Windows admin account can get in. Here are your options.
SQL SERVER – Maximizing View of SQL Server Management Studio – Full Screen – New Screen
Two ways to get more room in SQL Server Management Studio: show results in a separate tab and switch SSMS to full screen, from my TechEd India 2009 demo.
SQL SERVER – SQL Server Management Studio New Features
The top 5 new features of SQL Server Management Studio 2008, the tool that replaced Enterprise Manager and Query Analyzer, with upgrades DBAs asked for.
SQL SERVER – 2008 – SSMS Feature – Multi-server Queries
SSMS 2008 lets DBAs run one query against many servers from one window. Here is how multi-server queries work, a tip from my TechEd India session.
SQL SERVER – 2008 – Customize Toolbar – Remove Debug Button from Toolbar
SQL Server 2008 brought the debugger back, and its button sits right next to Execute. Here is how to customize toolbar buttons and remove the debug button.