Tag: performance

Sort: Date | Title | Views | Comments Sort Ascending

A Better Way to Read Execution Plans Part 1

Added by 5 years ago

5.25K Views0 Comments

Kevin goes over how to do basic query tuning. Then he dives into 3 real world query tuning examples that are taken from Answers.SQLPerformance.com. The examples are SSMS vs. Plan Explorer, Massive MERGE, and the Case of the Log Shipping Mystery.

Ad-Hoc Sets

Added by 5 years ago

3.47K Views0 Comments

Aaron Bertrand goes over how to generate Ad-Hoc Sets efficiently. He shows examples of how to generate them using recursive CTEs, system tables and number tables and shows which way has the best performance.

Add Target

Added by 2 years ago

6.67K Views0 Comments

This video is part of the Getting Started Series found on the SQL Sentry client software start page. These videos are intended to give you a basic understanding of some of the features of the product. This video will ...

Columnstore Indexes Improvements in SQL Server 2016 with Niko Neugebauer

Added by 3 years ago

4.54K Views0 Comments

In this session, Niko Neugebauer looks at the columnstore indexes and discusses how they've improved in SQL Server 2016. About the speaker: Niko Neugebauer works as a BI Consultant for OH22, which creates int...

Comma Delimited Parameters

Added by 5 years ago

4.04K Views0 Comments

Aaron Bertrand discusses one of his favorite topics, comma-delimited parameters. He shows the different ways you can split strings and which ways are the best.

End-To-End Troubleshooting on Microsoft SQL Server

Added by 4 years ago

6.74K Views0 Comments

In this video, SQL Server MVP Kevin Kline discusses how to go about troubleshooting and performance tuning your Microsoft SQL Server without any paid professional tools. He goes through his methodology for troubleshooting, which he has learned over the course of many years of trial and error.

Execution Plan Self-Destruct

Added by 5 years ago

2.66K Views0 Comments

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.

Exploring SQL Server’s Plan Cache

Added by 3 years ago

2.58K Views0 Comments

SQL Server’s plan cache is one of the largest regions of memory and is used to store SQL and T-SQL code for quick execution. It is largely self-maintaining and self-tuning. However, the kind of code you write and the way you invoke that code can have an enormous impact on how the plan cache is maintained, tuned, and optimized.

Fragmentation Manager Overview

Added by 7 years ago

5.23K Views0 Comments

SQL Sentry Fragmentation Manager introduces new automated index maintenance capabilities to Performance Advisor. In the video, Steve Wright discusses how Fragmentation Manager improves the manageability and vis...

Implicit Conversions

Added by 5 years ago

3.62K Views0 Comments

Kevin Kline goes over implicit conversions in SQL Server. He discusses what an implicit conversion is, traps that people fall into with implicit conversions and gives a demo on avoiding implicit conversions. ...

Performance Advisor Dashboard

Added by 7 years ago

28.70K Views0 Comments

SQL Sentry’s Performance Advisor dashboard not only gives you real time performance details on your server, but also easily provides long term trending as well as flexible point in time details for all of your S...

Plan Explorer Demo by Jonathan Kehayias (SQLskills)

Added by 7 years ago

4.24K Views0 Comments

Plan Explorer takes plan analysis to an entirely new level by making it easy to snap to the most expensive operator inside of an execution plan, change the default display to show cumulative costs instead of per...

Page 1 of 3123