_sql-server-query-tuning-best-practices-part-2.jpg "SQL Server Query Tuning Best Practices - Part 2 from vs code sql server Video Screenshot Preview")
GalleryPlay Video:
(Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
⏲ Duration: 40 min 6 sec
✓ Published: 20-Jun-2013
✓ Published: 20-Jun-2013
Description:
SQL Server MVPs Aaron Bertrand and Kevin Kline continue their series on query tuning best practices. Kevin starts by talking about what you should include in test harnesses for testing your SQL code and how to isolate it and stabilize your environment in order to get consistent results. He then gives some tips on how to assess those results. The patterns and anti-patterns that are in the video are UNI0N vs. UNI0N ALL, Index Structures, and Compound Indexes. Aaron and Kevin include Covering Index
SQL Server MVPs Aaron Bertrand and Kevin Kline continue their series on query tuning best practices. Kevin starts by talking about what you should include in test harnesses for testing your SQL code and how to isolate it and stabilize your environment in order to get consistent results. He then gives some tips on how to assess those results. The patterns and anti-patterns that are in the video are UNI0N vs. UNI0N ALL, Index Structures, and Compound Indexes. Aaron and Kevin include Covering Index
Share with your friends:
Whatsapp | Viber | Telegram | Line | SMS
Email | Twitter | Reddit | Tumblr | Pinterest
Related Videos
_how-to-connect-sql-server-with-visual-studio-code.webp "Adam Tech")
_phillydotnet-org-codecamp-2009-2.webp "Our second 2009 Code Camp will be held at the DeVry University campus in Fort Washington, PA on Saturday, October 17 from 8:30-5:00. Please register on our web site. Detailed directions are on the DeVry web site.nnLots of code, just say no to slides!n8 hoursn60 sessions (8:30, 10:00, 12:30, 2:00, 3:30)n12 tracks including two hands-on Beginner rooms and the Bonus Trackn600 seats with tables (laptops welcome)nFree breakfast, lunch, and afternoon snack (expanded menu!)nRaffles and prizes at 5:00nE")
_connecting-ms-sql-server-in-visual-studio-code-124124-step-by-step-tutorial-for-beginners.webp "Cool IT Help")
⏲ 8 minutes 38 seconds 👁 6K
_how-to-run-sql-server-using-visual-studio-code-124-vs-code-sql-server-extension.webp "Programming Guru")
⏲ 12 minutes 23 seconds 👁 10.3K
_connect-to-mysql-database-from-visual-studio-code-and-run-sql-queries-using-sqltools-extension.webp "BoostMyTool")
⏲ 9 minutes 9 seconds 👁 354K
_how-to-easily-connect-sql-server-2022-in-visual-studio-code-and-run-sql.webp "Programming Guru")
_sql-server-query-tuning-best-practices-part-5.webp "SQL Server MVPs Aaron Bertrand and Kevin Kline continue their series on query tuning best practices.In the webinar, they continue to discuss some additional patterns, things that do well and make your SQL code perform better, and anti-patterns, which are things you want to avoid and stay away from.Aaron goes over the “Kitchen Sink” stored procedures and SP_Execute SQL vs. EXEC( ) and when to use each. Next, Kevin goes over what can cause your execution plans to self-destruct.Finally, A")
_connect-to-sql-server-using-visual-studio-code-2022-and-run-sql-queries-create-read-update-delete.webp "BoostMyTool")
⏲ 14 minutes 6 seconds 👁 36.8K
_how-to-connect-sql-server-with-visual-studio-code.jpg)
_phillydotnet-org-codecamp-2009-2.jpg)
_connecting-ms-sql-server-in-visual-studio-code-124124-step-by-step-tutorial-for-beginners.jpg)
_how-to-run-sql-server-using-visual-studio-code-124-vs-code-sql-server-extension.jpg)
_connect-to-mysql-database-from-visual-studio-code-and-run-sql-queries-using-sqltools-extension.jpg)
_how-to-easily-connect-sql-server-2022-in-visual-studio-code-and-run-sql.jpg)
_sql-server-query-tuning-best-practices-part-5.jpg)
_connect-to-sql-server-using-visual-studio-code-2022-and-run-sql-queries-create-read-update-delete.jpg)
![[+]](/images/menu.gif){kind=small}