137 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.
202 Views0 Comments0 Likes
Aaron Bertrand discusses the issues of using the MERGE statement. He also gives a few ways to avoid using it.
224 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.
215 Views0 Comments0 Likes
Aaron Bertrand discusses the issues of using the “Kitchen Sink” procedure, which is a stored procedure with massive dynamic search parameters. He shows examples of why the procedure is bad and ways to work around it.