Performance

Tools: SQL Sentry Plan Explorer is completely FREE for everyone

8 Sep, 2016 in Execution Plan / SQL Server / Tool tagged Execution Plan / Optimization / Performance by Peter Lalovsky

There is a great news today for SQL Server community – SQL Sentry (RSS: SQLPerformance.COM) Plan Explorer is FREE for everyone. Download User Guide Thank you, SQL Sentry! Keep it simple :-)

T-SQL Optimization: Nonclustered Index and GROUP BY

6 Jan, 2015 in Optimization / T-SQL tagged Optimisation / Performance / The Price I Pay by Peter Lalovsky

In this example I play with the performance of a query that groups the data.