Earlier you saw query statistics only after a query finished. In Notes from the Field #111, Mike Lawell shows Live Query Statistics in SQL Server 2016 and more.
Interview Question of the Week #053 – What is the Difference Between Deterministic Functions and Nondeterministic Functions?
What is the difference between deterministic functions and nondeterministic functions in SQL Server? A short interview answer with examples.
SQL SERVER 2016 – New T-SQL Functions – COMPRESS – DECOMPRESS
SQL Server 2016 adds two new string functions, COMPRESS – DECOMPRESS. Here is how they work, with examples, and the error you get on older versions.
SQL SERVER – Could Not Register Service Principal Name Persists – Notes from the Field #105
Seeing ‘Could not register the Service Principal Name’ in your SQL Server log at startup? In Notes from the Field #105, Ryan Adams explains why and what to do.
SQL SERVER – Availability Group and the Six Critical Steps for DBAs to Follow – Notes from the Field #104
Mike Lawell shares six critical steps every DBA should follow when asked to implement an AlwaysOn Availability Group. Notes from the Field #104.
SQL SERVER – T-SQL Window Function Framing and Performance – Notes from the Field #103
Kathi Kellenberger shows how window function framing and performance are linked, and why relying on the default frame can hurt. Notes from the Field #103.
SQL SERVER – What is T-SQL Window Function Framing? – Notes from the Field #102
Kathi Kellenberger explains T-SQL window function framing, added in SQL Server 2012, and how frames help with running totals. Notes from the Field #102.