Discover the secrets to unlocking lightning-fast database performance! In this engaging presentation, Bryden will guide you through a range of tried-and-true techniques that will revolutionize the way you approach database optimization.
00:00 | 00- Intro
04:16 | 01- Reduce Table Size
10:55 | 02- Use SELECT fields FROM
14:36 | 03- Create Indexes
17:16 | 04- Verfy Indexes
21:14 | 05- Avoid Implicit Conversions
23:42 | 06- Avoid Looping
26:50 | 07- Use AND instead of OR
30:00 | 08- Minimize Large Writes
32:29 | 09- Avoid Wildcards LIKE ‘%fred”
36:04 | 10- Create Joins with Inner Joins
38:20 | 11- Use Exist() instead of count()
40:51 | 12- Avoid SELECT DISTINCT
42:48 | 13- Avoid too many joins
44:48 | 14- Use TOP for sampling
46:51 | 15- Use WHERE instead of HAVING
49:16 | Summary
56:06 | Q and A
With plenty of live demos along the way, you’ll gain a deep understanding of each technique and learn how to apply them to your own databases. From the simplest tips to more advanced techniques, this session has something for everyone.
Get ready to take your database performance to the next level! This session is aimed at making databases more accessible to developers. Aimed squarely at SQL Server, it contains lots of little tips and tricks along the way to help quickly and easily identify problem queries.
Links:
Need help?: https://ssw.com.au/ssw/Consulting
Follow us:
LinkedIn: / ssw
Twitter: / ssw_tv
Facebook: / ssw.page
Instagram: / ssw_tv
Tiktok: / ssw_tv
Get in touch:
Bryden Oliver – SSW Solution Architect
About: https://www.ssw.com.au/people/bryden-oliver
https://github.com/brydeno
For more information about SSW’s consulting services, please visit https://ssw.com.au
#database#sql#databaseperformance#data#tech#usergroup
V1 – Bahjat
About the speakers
Bryden Oliver
Bryden is a Solution Architect with over 30 years of professional experience, working with customers from small businesses to the world's largest companies. He has a wealth of knowledge from a diverse range of areas, particularly focused on databases, web services, Microsoft Azure, and SaaS solutions. Bryden has a strong understanding of how software will deliver business value.
Related videos
