1.79K Views2 Comments0 Likes
SQL Server MVP Kevin Kline discusses the top 10 administrative mistakes that DBAs make on Microsoft SQL Server. He discusses how most of the mistakes are due to process and business issues instead of issues with technology.
300 Views0 Comments0 Likes
Kevin Kline discusses how SQL Server wants to reuse execution plans but there are issues that can cause execution plans to never be reused. He also shares some examples of how to fix these issues which will help improve SQL Server performance.
358 Views0 Comments0 Likes
Aaron Bertrand discusses the issues of using the MERGE statement. He also gives a few ways to avoid using it.
382 Views0 Comments0 Likes
Kevin Kline goes over how to tune SQL queries involving statistics on temp tables, slow performance on an update to NULL values, a slow insert, and lots about parallelism. This is the 3rd episode of the “A Better Way to Read Execution Plans” webinar series.